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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives