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
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 507 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 308 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!