CountIfs formula

Phillip.Henrybhsi ✭✭✭
edited 12/15/23 in Formulas and Functions

Hello Everyone,

I am trying to get a percentage for a dashboard to work. I have three categories, Not quoted, quoted, and PO issued. I am trying to have my PO issued take into account the items that have already been quoted. For example, on my dash board if everything is quoted (checkbox) and everything has a PO (text) the pie chart shows 50% for each. I need a way for when lines have a PO number that is deducts the quoted items and shows that everything has been assigned a PO number.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!