Pulling specific modifications dates from the past

Kelsey Ciarrocca

Hi! I am tracking documents that need to be signed. I have a status column that tracks if it's "signed", "unsigned", or "refused". I'm needing to go back and collect the dates that they were turned to "refused". Too much time has gone by, and so the modification date field doesn't work. Looking at each cell history would take too much time to go one by one (there's about 2000 records)... is there a better way to do this?

I'm open to any ideas! Thank you :)

Kelly Drake

Not sure if this idea scales well or not - but wondering if you could look at the activity log to pull that data - you'd really need to manipulate the log to gt to the data point you're looking for though. I've not found a scalable/automated way to do this on historical data.

Andrée Starå

Hi @Kelsey Ciarrocca

I think the only solution would be a 3rd party solution or the Smartsheet API.

Are those viable options?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!