Calculate Date based on Criteria in Two Cells

I need to write a formula to check a cell for a size (Small, Medium, or Large) and calculate a start date from a go-live date in another cell. If the size is small, it's 14 days earlier, if it is medium, it is 21 days earlier and if large 28 days earlier.

I've go this as my starting point: =IF([Size]@row, Small,[Go-Live]-14) but so far it's unparseable.

Thanks for the help

Andrew

Find more posts tagged with

Formulas

Project Management

Accepted answers

Bassam Khalil

Hi @Andrew Lucia

Hope you are fine, please try the following formula and convert it to a column format formula:

=IFERROR(IF(Size@row = "Small", [Go-Live]@row - 14, IF(Size@row = "Medium", [Go-Live]@row - 21, IF(Size@row = "Large", [Go-Live]@row - 28))), "")

All comments

Bassam Khalil

Hi @Andrew Lucia

Hope you are fine, please try the following formula and convert it to a column format formula:

=IFERROR(IF(Size@row = "Small", [Go-Live]@row - 14, IF(Size@row = "Medium", [Go-Live]@row - 21, IF(Size@row = "Large", [Go-Live]@row - 28))), "")

Andrew Lucia

Thanks, Bassam - I am new to Smartsheet and can see I still have a lot to learn. Your solution worked great.

Andrew

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.