Have a column to auto-populate "last modified" date for a row
We don't always have all our data upfront and have to fill in the missing pieces over time. There are several people making changes but we don't know when or what. A column could have a "last modified" auto-populated when any change to a row is made, then we'd know which row to gather info from.
I got a spreadsheet with a lot of dates each with a unique function within one row
The last column I would like to add DONE if all the dates is added (but if there is one missing it must indicate the row as “Outstanding”
Did try some formulas but do not get it right