Countifs on a column that is a multi-select drop down..

Options

I am trying to do a countif and one of the fields is a multi-select drop down and isn't returning the correct value, no idea what to do

R4+ BP007 Change Inventory Range 1 is the field that is the multi-select column.

=COUNTIFS({Status}, =[01 Open]$1, {Primary Function}, =$[Primary Column]5, {Fit/Gap}, ="Gap (Core Process)") + COUNTIFS({Status}, =[01 Open]$1, {Primary Function}, =$[Primary Column]5, {Fit/Gap}, ="Gap (Local Process)") + COUNTIFS({Status}, =[01 Open]$1, {Primary Function}, =$[Primary Column]5, {Fit/Gap}, ="Gap (Non-functional)", {R4+ BP007 Change Inventory Range 1}, $[01 Open]$10)

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!