Referencing the Activity Log

RobSalvaggio1987

Hello,

Is there a way to programmatically reference the activity log? My organization is trying to reference the change date of a project status field and we want to track when projects have hit certain milestones (and also when those milestones were hit on past projects tracked within smartsheet). Is there a way to reference this information other than just looking at it? I've tried exporting this information and it isn't very useful for what we're doing.

Thank you!

AnthroTim

Hi,

I wonder if an automation on a field change that sets a time stamp might be the way to go.

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.31764862.1590226978.1649162913-398963795.1648509623

that way it would be data that could be reported on within Smartsheet.

That doesn’t help with historic data sadly. You’d have to set the dates on those manually.

Tim

anthrotechnic.com

Andrée Starå

Hi @RobSalvaggio1987

I hope you're well and safe!

To add to Tim's excellent advice/answer.

Another option, especially if you need to have the time, could be the following.

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!