Formula to calculate date

Berenice Vanderley

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?

Paul Newcome

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.

Berenice Vanderley

I think I might have found the trick, use - instead of + in the lag

Paul Newcome

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.

Berenice Vanderley

Thank you so much Paul!