Last modified for specific cell
Hi!
I am trying to figure out if there is a formula to basically look at a cell and see when a specific cell is modified. I am trying to use this for KPIs.
For background:
I have a workflow where if something is rejected by my engineering department the person who created the request is then triggered to answer engineering's specific reason for rejection. I need to basically know the date that engineering created the rejection, and the date that the rejection was clarifying information was responded to by the non-engineering individual. Is there a way to do this?
Best Answer
-
Hey @Jivi3
You can use a Record a Date action block in a Workflow to add a date to a column in your sheet when something specific changes. It sounds like you'll want to add that to your Update Request workflow. Here's more information: Set the current date with the Record a Date action
Cheers,
Genevieve
Answers
-
Hey @Jivi3
You can use a Record a Date action block in a Workflow to add a date to a column in your sheet when something specific changes. It sounds like you'll want to add that to your Update Request workflow. Here's more information: Set the current date with the Record a Date action
Cheers,
Genevieve
-
This worked great!!! Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!