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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!