Count if referencing other sheet with checkbox in criteria
Trying to count the number of projects where status = High Priority List View and the Delivery box is checked off. Sheet is already reference but can not get formula here
Answers
-
I don't know if you need the "AND" formula in this instance because COUNTIFS already looks at all listed criteria. Also, the first reference doesn't look right. Are you getting an error when you enter it?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!