Need a box checked if one of two criteria is met

TracyM ✭✭✭
edited 09/21/22 in Formulas and Functions

Hi! I have a column and I need the box to check if a student's disability is Intellectual Disability or Multiple Disabilities. I have the formula correct if it's just one:

=IF([Primary Disability]@row = "Multiple Disabilities", 1, IF([Secondary Disability]@row = "Multiple Disabilities", 1, IF([Tertiary Disability]@row = "Multiple Disabilities", 1, IF([Quaternary Disability]@row = "Multiple Disabilities", 1, 0))))

But I can't figure out how to get it to work if it's either/or.

thanks in advance for any help you can offer!

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓


    You can use CONTAINS to search for a value within a range of cells. If all 4 columns are next to each other starting with Primary on the left and ending with Quaternary on the right, try this:

    =IF(OR(CONTAINS("Multiple Disabilities", [Primary Disability]@row:[Quaternary Disability]@row), CONTAINS("Intellectual Disability", [Primary Disability]@row:[Quaternary Disability]@row)), 1, 0)

    In English: If the text string "Multiple Disabilities" or the text string "Intellectual Disability" is found anywhere in these four columns on this row, check the box, otherwise, don't check the box.


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!