Using nested ISBLANK

I would like build a nested ISBLANK equation that looks at two cells and if both are blank, then give "X", if one of the two cells is blank gives "Y" if neither are blank results in "Z".

I tried

Answers

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Guy,


    You may want to use a count formula for this. Here's what worked for me:

    =IF(COUNT([Column2]@row:[Column3]@row) = 0, "X", IF(COUNT([Column2]@row:[Column3]@row) = 1, "Y", IF(COUNT([Column2]@row:[Column3]@row) = 2, "Z")))


    Best,

    Heather

  • Hi Heather,

    Thanks for this. Makes perfect sense. However I am getting #unparseable:

    =IF(COUNT([Subject15]@row:[Subject17]@row) = 0, "X", IF(COUNT([Subject15]@row:[Subject17]@row) = 1, "Y", IF(COUNT([Subject15]@row:[Subject17]@row) = 2, "Z")))

    Thanks again.

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Guy,

    I don't see any errors in your formula. I changed my headers to match yours, and they are identical. Try copying and pasting this:

    =IF(COUNT([Subject15]@row:[Subject17]@row) = 0, "X", IF(COUNT([Subject15]@row:[Subject17]@row) = 1, "Y", IF(COUNT([Subject15]@row:[Subject17]@row) = 2, "Z","")))

    Also, feel free to provide a screenshot and block any sensitive information. That may help identify the issue.


    Best,

    Heather

  • Heather,

    Thank you very much for the speedy reply. No luck. Image below:


  • Heather,

    Got it...:)

    =IF(COUNT(Subject5:Subject7) = 0, "Nothing Scheduled", IF(COUNT(Subject5:Subject7) = 1, "One Spotlight Scheduled", IF(COUNT(Subject5:Subject7) = 2, "Two Spotlights Scheduled", "")))


    Thanks!


    Guy

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Ah! The @row got in the way! Nice catch.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!