Hi everyone, Few questions all interrelated. * I disguised my actual field names, but this returns a blank cell.... how can that be? Shouldn't it return either Done or Not Done? * I added ,"x" after Not Done and it didn't break it. Still returned blank cell. Odd that I did not get an UNPARSABLE message. * First attempt, I built this in Word and copied it into Smartsheet. Same exact character for character, but kept getting UNPARSABLE message. Even used CLEAN function in Excel to remove hidden chars, but still returned UNPARSEABLE. When I keyed it in character by character into Smartsheet, it did not throw the UNPARSEABLE. =IF([1Status]@row <> "N/A", IF([1 Status]@row = "Done", IF([2 Status]@row <> "N/A", IF([2 Status]@row = "Done", IF([3 Status]@row <> "N/A", IF([3 Status]@row = "Done", IF([4 Status]@row = "N/A", IF([4 Status]@row = "Done", "Done", "Not Done")))))))) Rather bewildered, Tim

Nested IF

palmcitytim

Hi everyone,

Few questions all interrelated.

I disguised my actual field names, but this returns a blank cell.... how can that be? Shouldn't it return either Done or Not Done?
I added ,"x" after Not Done and it didn't break it. Still returned blank cell. Odd that I did not get an UNPARSABLE message.
First attempt, I built this in Word and copied it into Smartsheet. Same exact character for character, but kept getting UNPARSABLE message. Even used CLEAN function in Excel to remove hidden chars, but still returned UNPARSEABLE. When I keyed it in character by character into Smartsheet, it did not throw the UNPARSEABLE.

=IF([1Status]@row <> "N/A",

IF([1 Status]@row = "Done",

IF([2 Status]@row <> "N/A",

IF([2 Status]@row = "Done",

IF([3 Status]@row <> "N/A",

IF([3 Status]@row = "Done",

IF([4 Status]@row = "N/A",

IF([4 Status]@row = "Done", "Done", "Not Done"))))))))

Rather bewildered,

Tim

Find more posts tagged with

Accepted answers

palmcitytim

We worked around it by developing a different formula. As for the #unparseables, I cannot recreate it now but when it happens again I'll provide screenshots of the copy/paste workflow.

All comments

palmcitytim

Let me add that all of the status fields are of type Dropdown Single-select, and it has five choices, of which 2 are N/A and Done.

Sandhiya07

Hi @palmcitytim ,

Hope you are Good and Safe!

If you are ok means Could you please explain it with Screenshots so that it would be easy to understand.

Thanks,

Sandhiya P

palmcitytim

We worked around it by developing a different formula. As for the #unparseables, I cannot recreate it now but when it happens again I'll provide screenshots of the copy/paste workflow.

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.