Add single use functions
I’ve thought of a couple of functions that would be helpful.
A GetSingleDate function. If you put this in an empty cell, it returns the current date and won’t update again. In a Table it would have the effect of being a date created value for that row.
AutoNumber. Like MS Access, it returns the next number in sequence. After it gets a number the first time, it won’t increment again. In a table it would be just like autonumber in Access. Parameters could be starting number and increment.
I have implemented both of these with VBA and they have been helpful.
A.C. WILSON commented
Unlike the other Office programs, which MS wrote, Visio (which MS purchased fully formed) can display both date-time of the most recent update and the present date-time. Very useful for printed/PDFed snapshots.
They'd be most useful in Tables due to the manner in which new rows are populated with formulas when being initiated.
Outside of Tables, they'd not be much use in a pre-populated area as they'd take on a creation moment value that wouldn't really match a first-use situation. If one knew already what to put there, they'd be unneeded, so either way... In a user-created situation, like a VBA initiated creation, a simple line or two of code would solve that as it could enter the values desired when creating whatever is being set up. Only if the user is copying and pasting or writing the formula directly would they help then.
Perhaps handier would be a broader thought: a FREEZE() function that calculates once, then never again. Tricky to logic out, but inside an IF() it could test for things like completeness of a record (for example, a full row of data vs. a not yet full row of data, in whatever manner made sense to the creator), and once the IF() found itself executing the FREEZE() option, it would calculate and never do so again.
Well, something like that. But there ought to be a way to make DATE() or TIME(), at least, calculate once and never again without user intervention via some manner of editing or pasting over the cell contents.