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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives