Nested If, then, CountIf formula
Hello, I am trying to create a nested If, CountIf formula, wherein the formula refers to a column and only counts status if that column is = to 1 of the 4 options. Then, ideally divide the # returned by the total to return the status over all %.
For example if Column: Address is equal to: ABC Street, then Count Status column "In Progress" as 1 and then divide the total # of "In Progress" returned by 50 for total %
Answers
-
I found the issue, the column had a space and I had not placed the brackets around it. I then created a separate column to perform the % complete equation and now have 2 widgets on the dashboard. 1) to show how many, as a # in each status stage and 2) the % complete for each status stage.
=COUNTIFS(Address:Address, "ADC Street", [Application Status]:[Application Status], "In Progress")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!