COUNTIFS using OR nested within 1 of the criteria sets

Lori Drum
✭✭✭
Hello Smart Smartsheet People,
I have a sheet with a Status column and an End Date Column. I need to get a count of the number of rows that have a Status of (Not Started or In progress or On Hold) AND where the End Date is in the past. Here's what I've tried:
=COUNTIFS({1-Project Plan Status},OR(@cell="Not Started",@cell="In Progress",@cell=On Hold),{1-Project Plan End Date},<TODAY)
What am I doing wrong? I throw myself on your mercy. Thank you!
-- Lori
Answers
-
Hi @Lori Drum,
Try adding "()" after TODAY:
=COUNTIFS({1-Project Plan Status},OR(@cell="Not Started",@cell="In Progress",@cell=On Hold),{1-Project Plan End Date},<TODAY())
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 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!