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?

Find more posts tagged with

Calendar View

Gantt View

Cell linking

Accepted answers

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.

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.