System Column - Last Modified
Hi everyone!
Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified"
Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the sheet updates as if it were modified.
Any feedback would be greatly appreciated!
Thank you!
Lisa
Comments
-
Are you using the TODAY() function in a formula in all of those rows?
-
Ahh... yes, I am. That's the culprit:) I knew there was something within the sheet causing chaos!
Any thoughts on a work around?
-
Here is my suggestion...
Approver column is Contact type.
Add Date type column.
Change workflow from Approval to Update Request and send the contact and date columns. Approver enters their name and the approval date.
Set workflow to run based on the submission date column being 10 days in the past with a condition of the approval date column being blank.
-
Thank you for the suggestion!
-
Happy to help!
Let us know how it works out for you.
-
Hi Lisa,
Another option could be the third-party service, Zapier. It's an excellent option for this scenario. Is that an option for you?
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!