I need dates formula and automation help please!
please help me determine the following:
I need a formula to automate notifications on the date when we need to be notified based on the criteria below
send notification 90 days before written notification has to be sent if the notification has to be sent 30 days before the term end, 105 days if notification has to be sent 45 days before term end, 120 days if the termination notice has to be sent 60 days before term and 150 days if the termination has to be sent 90 days before term end.
this will allow us 60 days to be notified before we have to send the written notification to terminate an agreement.
I have these columns on my worksheet:
I haven't figured out the formula to output the actual dates on my worksheet. workflow notification. Thank you for any help!
Answers
-
@WinaHath What determines if the notification should be sent 30, 45, 60, 90 days prior to term end.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!