Using Multiple IF Statements

Torri B.
Torri B. ✭✭
edited 12/09/19 in Formulas and Functions

Hello,

As Smartsheets does not allow for multi-select dropdown lists, I am trying to work a way around this using checkboxes and IF statements but keep running into a roadblock.

I want it to say:

If theΒ "Chemotherapy" checkbox is selected in Column A, Column E says "Chemotherapy" . If the "ICU" column is selected in Column B, Column E says "ICU" --- I have been able to accomplish both of these using basic IF functions. But what I need it to do next is say "If "Chemotherapy" and "ICU" checkbox is selected, Column E says "Chemo, ICU"Β 

I've tried =IF(Chemo1 = 1, "Chemo,"Β IF(ICU1 = 1, "ICU,")) and that works for Chemo, but the IF statement takes the first item listed as the top priority, so it only works if one or the other is selected but not both.

Β 

Any thoughts?Β 

Β 

Thanks!Β 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!