Check Box & IF Statements
Appreciate some pointers on this if possible..
I have 5 Columns in my Smartsheet.. the first 4 are Check Boxes, the 5th is a Text/Number.. Columns as follows..
In [Direction], I want to display text dependant on the Checked Boxes status.. it can be any of the first 4 boxes or any combination of the boxes..
Using this formula =IF([North]1 = 1, "North ", "") I can get the "North "to display, but cannot work out how to modify the formula to then check for the other Columns.. for example, I have [North] and [South] checked, I would expect a return of "North " and "South "..
Appreciate your support..