COUNTIFS formula troubleshooting - multiple criteria and checkboxes
Hi SmartSheets Community,
I'm new to Smartsheet (but know some basic Excel), but am getting stumped on this formula. Can you advise what I'm doing wrong?
I'm trying to create a formula that 1) counts either Red or Blue cells in another spreadsheet column (Other Sheet Range 1), and then 2) counts a checkmark (or no check mark). When I enter this in, I get #UNPARSEABLE. Any guidance on what I'm doing wrong?
Checkmark formula:
=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, =1))
No Checkmark formula:
=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0))
Best Answer
-
Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1)
=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 1) =COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0)
Answers
-
Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1)
=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 1) =COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0)
-
Thank you Sameer!! This was driving me crazy, and I couldn't figure it out. Appreciate it!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!