Formula # UnParseable?

maynardg

I have a Smartsheet 4 columns are check boxes.

I want the check boxes to change a list column to the following.

If I check on Assigned then change list to Assigned

If I check on In Progress then change list to In Progress

If I check on Holding-See notes then change list to in Progress

If I check on Complete then change list to Complete

Here is the formula

=IF(Resolved@row = 1, "Complete"), IF(In Progress@row = 1, "In Progress")), IF(Holding-See notes@row = 1, "Holding-See notes")))

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @maynardg

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

status = =IF(Resolved@row = 1, "Complete", IF([In Progress]@row = 1, "In Progress", IF(Assigned@row = 1, "Assigned", IF([Holding-See notes]@row = 1, "Holding-See notes", ""))))

the following screenshot show the result

All comments

Bassam Khalil

Hi @maynardg

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

status = =IF(Resolved@row = 1, "Complete", IF([In Progress]@row = 1, "In Progress", IF(Assigned@row = 1, "Assigned", IF([Holding-See notes]@row = 1, "Holding-See notes", ""))))

the following screenshot show the result

maynardg

Thank You! It works...

Bassam Khalil

@maynardg

You are welcome

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.