CountIfs formula

Phillip.Henrybhsi

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.

Eric Law

https://community.smartsheet.com/discussion/114442/countifs-formula

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.

Eric Law

https://community.smartsheet.com/discussion/114442/countifs-formula

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.

Phillip.Henrybhsi

Thank you this worked.