Looking for a Formula that will count if multiple values are true

CoryG
CoryG ✭✭
edited 03/18/22 in Formulas and Functions

I am working to keep track of under represented minorities we have in our classes. We are able to get a formula that keeps track if they belong to one Like Hispanic or American Indian, but we do have some students who belong to more than one of these group. We use this formula for Instance to gather if they were Hispanic

=COUNTIFS([Declined / Deferred?]:[Declined / Deferred?], ="", Hispanic:Hispanic, "yes")

Say we have these columns set, Hispanic, American Indian, Asian, Black, Pacific Islander. Is there a way to have a formula that will keep track if any Student is Yes to any 2 or more of these?

Tags:

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 03/19/22 Answer ✓

    Hi @CoryG

    I hope you're well and safe!

    If the columns with the different options are side by side, you could try something like this in a checkbox column to have it checked if more than one option is Yes.

    =IF(COUNTIF(Hispanic@row:[Pacific Islander]@row, "Yes") > 1, 1)
    

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!