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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!