Looking for a Formula that will count if multiple values are true
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?
Best 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Sorry for the delayed response. Hope your week is going well. That worked perfectly! Thank you so much. Your a Hero!
-
No worries!
Glad to hear that it's working, and you're more than welcome!
My week is going fantastic, and I hope yours is too!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!