How can I count more than one status in a column
=COUNTIFs(([BTA Deployment Status]:[BTA Deployment Status], ="On Hold")([BTA Deployment Status]:[BTA Deployment Status], ="Credentials Needed"))
Where there are more than one status... "On Hold", "Credentials Needed", and "Complete"... but I only want to count the ones that are not complete
Answers
-
Hello Jeannie - Have you tried a helper column using an or statement? Something like COUNTIFS(OR([BTA Deployment Status]@row = "On Hold", [BTA Deployment Status]@row = "Credentials Needed", etc.)). From there, you could report, filter, etc. on rows where that helper column is
Hope this idea helps,
Scott
-
You have two options.
You can either exclude "Complete" like so:
=COUNTIFS([BTA Deployment Status]:[BTA Deployment Status], @cell <> "Complete")
Or you can use an OR function to include both choices like so:
=COUNTIFS([BTA Deployment Status]:[BTA Deployment Status], OR(@cell = "On Hold", @cell = "Credentials Needed"))
-
Thank you both! I'll play around with both options. Much appreciated!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!