CountIfs formula
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
-
My recommendation is to rename QUOTED to QUOTED - NO PO and rename PO ISSUED to QUOTED - PO ISSUED and update the QUOTED - NO PO to be what it is, minus the PO ISSUED number.
Answers
-
My recommendation is to rename QUOTED to QUOTED - NO PO and rename PO ISSUED to QUOTED - PO ISSUED and update the QUOTED - NO PO to be what it is, minus the PO ISSUED number.
-
Thank you this worked.
Help Article Resources
Categories
Check out the Formula Handbook template!