How can i make an automation to notify me 2 years before a due date?
I have a due date (e.g. 28/10/2027) and id like to be notified 2 years before the date. As smartsheet only allows me to set an automation 365 before a due date, I made a helper column which would bring back the date i should be notified. I used the formula below but i get an error.
=DATE(DAY([Due Date]@row), MONTH([Due Date]@row), YEAR([Due Date]@row) - 2))
Can someone please help?
Best Answer
-
Make sure both columns are formatted as date type columns.
Answers
-
Hi @Luka
It looks like you have an extra bracket at the end of your formula.
Also, double check the sequence of the DAY MONTH YEARI believe your formula should be:
=DATE(YEAR([Due Date]@row) - 2, MONTH([Due Date]@row), DAY([Due Date]@row))
Marcé Holzhauzen
Solution and Delivery Consultant with Award Winning Partner
Want to meet?Check my availabilitywww.prodactive.co.uk
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome. -
Thanks, for some reason i am now getting the #INVALID COLOMN VALUE error even though my column name matches what is in my formula?
-
Make sure both columns are formatted as date type columns.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives