Notifications when a date is now in the past
If a date in a cell under a date column is now in the past (i.e. the date hasn't been changed, its just now in the past) if it possible to automate a notification reminder to someone to do something?
All I can see in the notifications capability is the ability to send a notification if a row is actually changed or added.
Comments
-
Hi Chris,
Yes, it is. You can change the Trigger to On a specified date and for example 3 days after and select the Date Field that you want to base the alert from.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Thanks Andree. Do you know if you can do it outside of a trigger on a specified date? Can you trigger on anything that's now in the past?
-
Happy to help!
Yes, you can, but there needs to be something that has changed on the row. The trigger would be row-based, and then you would need to add a condition for a date column and that it should be in the past.
Ok?
Best,
Andrée
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 would suggest a helper checkbox column.
=IF(TODAY() > [Date Column Name]@row, 1)
This will check the box when the date is in the past. You can then build your Alert off of that. The only catch is... The TODAY() function will only update to the current date when the sheet is activated.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives