How to check is a cell is blank is multiple columns?

Options

Hello!

I am trying to create a formula on column X that checks if any cells on the row are empty. If one of them is, then show the "X" value, if all are not empty then, show the "O" value.

I used this =IF(ISBLANK([ICP Deliverables]3), "X", "O") to do it with just a column but I need it to check all columns, not just one.

Can someone help?

Thank you

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!