recurring annual reminder - contract renewal
I am trying to setup an automatic workflow to send me an annual reminder based on a date column that has a contract renewal date in it. When I do a custom automation I can allow it to recognize the date field on my sheet. seems like a simple task but I can't figure it out.
Best Answer
-
@Dhoke you can use that automation for the column you want to run it in. Just build a formula for the date in that column. For instance, if you have an Initial Date column and a Run Date column being the execution. You can put the following formula in the Run Date
=DATE(YEAR(TODAY()), MONTH([Initial Date]@row), DAY([Initial Date]@row))
Answers
-
Something like this? Set an automation reminder for a specific date 1 year out
-
I need to it remind me each year at the same time so that wouldnt work.
-
@Dhoke you can use that automation for the column you want to run it in. Just build a formula for the date in that column. For instance, if you have an Initial Date column and a Run Date column being the execution. You can put the following formula in the Run Date
=DATE(YEAR(TODAY()), MONTH([Initial Date]@row), DAY([Initial Date]@row))
-
Thanks. I think it worked I just had to change the names.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other …
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicen…
