Formula: 5 Checkboxes in Nested IF statement

System

This discussion was created from comments split from: Check Box & IF Statements.

Gunn_Jack

Hi all,

I know this is a bit of an old post but i am having a similar problem and was hoping someone could help.

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? Also i couldnt quite get my head around the above. 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

Paul Newcome

@Gunn_Jack I recently provided a solution to a question very similar to this. I will see if I can find it.

Paul Newcome

@Gunn_Jack It looks like it was on another one of your posts...

https://community.smartsheet.com/discussion/comment/249788#Comment_249788

Did that not work? Do you need something different?