COUNTIFS

I am trying to create a COUNTIFs for a metric that I need for COVID-19 tracking.

I have a datasheet: LOB, and Record Type

LOB is a drop down

Record type is a drop down either travel or isolation

I want to be able to pair up LOB and the # of employees in isolation (Record Type)

Example:

LOB (Corporte) : Record Type = Isolation (3)

Any help would be appreciated.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!