Need help adding an AND clause to a countif formula
ClanMcDe
✭
I have a metric sheet with a list of customers that counts the number of orders in an order sheet
The formula I am using is:
=COUNTIF({Analyst Request Tracker with Form Range 5}, Category52)
Need to add an AND clause based on status being equal to "In Progress, or "Not Started" (column located in the Analyst Request tracker with form sheet)
Any assistance appreciated.
Answers
-
Try the below one:
=COUNTIFS({Analyst Request Tracker with Form Range 5}, Category52, {Analyst Request Tracker with Form Range Status}, "In Progress") + COUNTIFS({Analyst Request Tracker with Form Range 5}, Category52, {Analyst Request Tracker with Form Range Status}, "Not Started")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!