Formula if multiple choices

I have a Countifs formula that I can get to work if a single item is selected from the dropdown but not if both options are selected.

I want to count:

1) Who's affected is Internal (works): =COUNTIFS({ProjectStatus}, "Open", {WhoAffected}, "Internal", {Live}, "Live Input")

2) Who's affected is External (works): =COUNTIFS({ProjectStatus}, "Open", {WhoAffected}, "External", {Live}, "Live Input")

3) Who's affected is BOTH Internal and External - NEED HELP PLEASE.

PS there are only two choices in that dropdown.

Thank you!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!