Nested IF

Hi everyone,

Few questions all interrelated.

  1. 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?
  2. 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.
  3. 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

Best Answer

  • palmcitytim
    palmcitytim ✭✭✭✭
    Answer ✓

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!