I need to be able to create a date column that can tell me the date that cells in another column last changed. Could be a column type or a formula
I don't have any way of ageing a data set at scale. I can look at individual cell history, but I need to date all cells in a column and sort or filter by age.
What I would do in this instance is set up a regular Date column then use a Record a Date workflow to record when a change is made in that other column. Here's more information
Let me know if this solves for your idea!
Cheers,
Genevieve
I am testing this solution now. There seems to be quite a few restrictions:
I may have an issue with "Smartsheet doesn't initiate the Record a date action when the trigger cell includes cross-sheet formulas or are linked to other cells."
Also, it wont retro record on the 2000 rows I already have in the sheet… just on rows that change from today forward. So I would still want a formula that looks at each cell's history and records the last date a change occurred.
Ill turn it on and let it run a couple days to see what happens.
Thanks for the info.