How do we create CASE statements in Smartsheet by Multiple IF statements?

I'm having an UNPARSEABLE error when trying to createa a formula to get a "30 Days" category from a field which used to be "free-form" and recently just became a dropdown. Hence I get "30 Days" or "30 days" in the field. Below is the formula, what is causing the error?

=IF(CONTAINS("30 Days",[Business Retention],1),"30 Days",

IF(CONTAINS("30 Days",[Business Retention - Other],1),"30 Days",

IF(CONTAINS("30 days",[Business Retention],1),"30 Days",

IF(CONTAINS("30 days",[Business Retention - Other],1),"30 Days", "Others"))))

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @molson ,

Try putting "@row" after the column names and see if that helps. So each would look like this - "[Business Retention]@row" as an example.

Hope that helps,

Dave

molson

Thank you Dave! The @row worked together with removing the ",1" inside the CONTAINS arguments.

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.