COUNTIF Question
Hello,
I have a master list where I log all support requests with a summary of the request, due dates, ECD health ect. On my master list sheet, there is a dropdown column where I label the task health as either "in progress", "overdue", or "resolved." On a separate metric sheet, I am trying to use the COUNTIF formula that will count the number of tasks labeled with respect to the categories stated in the previous sentence. The formula is giving me issues pulling in the correct category - I'm not sure if this is because the "Task Health" column has 3 separate values, or if there is an easier way to achieve this.
The formula I've been trying:
=COUNTIF({OrthoFi RAIL - Masterlist Range 5}, {OrthoFi RAIL - Masterlist Range 15})
Answers
-
@Gabriellenkv You can't have your Criteria be a range. So you will need to create 3 separate summaries.
=COUNTIF(RANGE, "Over Due")
=COUNTIF(RANGE, "In Progress")
=COUNTIF(RANGE, "Resolved")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!