Using nested ISBLANK

Options

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

• ✭✭✭✭✭✭
Options

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

• Options

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.

• ✭✭✭✭✭✭
Options

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

• Options

Heather,

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

• Options

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

• ✭✭✭✭✭✭
Options

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!