Formula to calculate date
Hello,
I am trying to work backwards but I just don't get it. My event date is my constraint, I want some tasks to be completed x days prior to the event and Smartsheet to calculate the start date of the tasks automatically. For example, send agenda to attendees 2 months prior to the event. I've tried playing with the SF/FS adding lag time but it isn't working.
Does anyone have a solution?
Best Answer
-
Yes. That should be correct. When working backwards like this it is usually beneficial to work with lead time instead of trying to use lag time.
Answers
-
I think I might have found the trick, use - instead of + in the lag
-
Yes. That should be correct. When working backwards like this it is usually beneficial to work with lead time instead of trying to use lag time.
-
Thank you so much Paul!
Help Article Resources
Categories
Check out the Formula Handbook template!