Using the OR function within a count formula referencing another sheet
Hey all,
Trying to work out how to add in the OR function to a count formual referencing another sheet.
Presently I've got.....
=COUNT(COLLECT({Activity}, {Row Type}, "Parent", {Status}, "Delayed"))
But the Status could be any of "Delayed", "In Progress" or "Client Delay"
Any help much appreciated!!
Thanks, Anna
Best Answer
-
Hi Anna, Unparsable is a syntax error. Usually something like a paren or comma out of place. I see 1 error, @cell has to be a lower case c.
Try: =COUNTIFS({Activity}, ISTEXT(@cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))
If that doesn't fix it, also confirm that your range names are correct and pointed to the correct external references.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Anna Keeton ,
Try:
=COUNTIFS({Activity}, ISTEXT(@Cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hey Mark - sadly I'm still getting unparseable with that :/. Thanks though!
Any other ideas?
-
Hi Anna, Unparsable is a syntax error. Usually something like a paren or comma out of place. I see 1 error, @cell has to be a lower case c.
Try: =COUNTIFS({Activity}, ISTEXT(@cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))
If that doesn't fix it, also confirm that your range names are correct and pointed to the correct external references.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 404 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!