Avoiding a massive nested IF formula - checkboxes?

Hi all,

I have 5 check boxes and based on these being ticked or unticked i want to display something in another cell.

It is essentially a decision tree that simply i want to work as follows:

If Group 2 is not ticked (or nothing ticked) = Group 1

If Group 2 is ticked but 3, 4, 5 & Close are not = Group 2

If Groups 2 & 3 are ticked but 4, 5 & Close are not = Group 3

If Groups 2, 3 & 4 are ticked but 5 and close are not = Group 4

If Groups 2, 3, 4 & 5 are ticked but close is not = Group 5

If Group 2, 3, 4, 5 & Close are ticked (all are ticked) = Close

Any ways of doing this simpler than building in every possible scenario via nested IFs? It is a linear structure in that 3 will not be ticked before 2 for example which i know avoids me having to do every combination.

Any help is much appreciated.

Thanks,

Jack

Best Answer

Answers

  • Gunn_Jack
    Gunn_Jack ✭✭✭✭

    Thank you Paul, that perfect.

    Jack

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!