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.
Help Article Resources
Check out the Formula Handbook template!