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



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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!