COUNTIF for multiple locations

Options

Hello SmartSheet Community,

I need a formula that will count the total number of locations in a multi-select drop-down column "Placement Location" and if the "SPAH Responsible" column = "Fred".

This is what I've been using but will not add multiple locations selected in one row. Do I need to add a sum formula in there?

=COUNTIFS([SPAH Responsible]:[SPAH Responsible], "Fred", [Placement Location]:[Placement Location],

For example, I need this to equal 3, not 2.

Thanks,

Alex Bostrom

University of Utah Health

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!