Countifs function returns #UNPARSEABLE

Hello,


I would like for the equipment status to be counted if it is "Issued", the equipment type is "Tablet" for a specific region. I have changed the formula multiple times, each time "UNPARSEABLE".

The formula below is the last one I used.

=COUNTIFS({Asset Tracker 2 Equipment Status}, {Asset Tracker 2 Equipment Status}, "Issued", {Asset Tracker 2 Equipment Type}, "Tablet", {Asset Tracker 2 Region}, [Office Location Information]@row])

Please advise on what correction are needed.

Thanks so much!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!