Can someone help with this formula

We are trying to read 4 columns and combine to get Status. It works in excel but not in smartsheet.

=IF(ISNUMBER(SEARCH("Other",[Sys_Class]@row)), "Others",IF(ISNUMBER(SEARCH("NO MATCH",[operational_status]@row)), "Completed",IF(ISNUMBER(SEARCH("Vernova Infra L2",[support_group]@row)), "Completed",IF([Planned Date of Exit]@row<TODAY(),"At Risk","On Track"))))

Find more posts tagged with

Accepted answers

All comments

SteveAtPathtoSummit

Looks to be structured properly, but something to consider would be to make sure the Planned Date of Exit column is a date format. Also, if any of the cells referenced are empty, it may cause issues too.

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.