Question: I’m trying to create a formula in Smartsheet with multiple conditions

Question:

I’m trying to create a formula in Smartsheet for a Date column ("Shipping Deadline") based on multiple conditions:

If the "Column B" cell already has a date, keep that value as an answer to this cell. If not then
If the "Column A" cell is blank, leave the result blank. If not then
If the "Column C" is either "User1" or "User2", subtract 21 days from the "Column A" date.
For any other value including blanks in Column C, subtract 16 days from the "Column A" date.

Both "Column A" and "Column B" columns are of Date type.

=IF(NOT(ISBLANK([Column B]@row )), [Column B]@row ,IF(ISBLANK(Column A@row ), "", IF(OR(Column C@row = "User1", Column C@row = "User2"),Column A@row - 21,Column A@row - 16)))

The above formula gave me an error "Invalid Column Value"

Find more posts tagged with

Accepted answers

Paul Newcome

Give this a go:

=IF([Column B]@row <> "", [Column B]@row, IF([Column A]@row <> "", [Column A]@row - IF(OR([Column C]@row = "User 1", [Column C]@row = "User 2"), 21, 16)))

All comments

Paul Newcome

Give this a go:

=IF([Column B]@row <> "", [Column B]@row, IF([Column A]@row <> "", [Column A]@row - IF(OR([Column C]@row = "User 1", [Column C]@row = "User 2"), 21, 16)))

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.