Is it possible? Have an IF formula to check certain boxes.

I have two columns Target Age and Target Grade. Can you have a formula that will look at the Target Age column and select the corresponding Target Grade. Both of them are multiple select drop down columns.

If 5-7 is selected, then check the box K-2nd grade, 8-10 is selected, then check the box 3rd-5th grade, 11-13 is selected, then check the box 6th-8th grade, and 14-18 is selected, then check the box 9th-12th grade. I can get it to check one box but not multiple options if needed.

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!