Nesting IF ISBLANK Formulas

Options

I have two columns with three possible outcomes

I can get these three formulas to work independently but not sure how to string them together.


=IF((ISBLANK(CEO1)), "CEO")

=IF((ISBLANK(CFO1)), "CFO")

=IF(AND((ISBLANK(CEO4)), ISBLANK(CFO4)), "BOTH")

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!