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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!