Tracking edits of one column only
I'm trying to track when end dates are changes in the project plan. I've added a system-generated column that will show when a whole row is modified, any way to limit that to one column? I need reporting capabilities that aren't possible with the activity log or cell activity functions. It also would be great if there was a conditional formatting rule for "is changed" for the date field!
Any ideas greatly appreciated! Thanks!
Comments
-
Hi,
You could use notifications in the Alerts & Actions section to set up a rule that would notify you when a change of a specific column happens.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I can think of a few Zapier Zaps that might help with this.
The cell history can also be extracted with the API.
You are right when you question whether the [Modified] date can be column specific. It can't.
Craig
