Countifs: Help with syntax in Countifs Formula with multiple conditions
Hello All, I am trying to return a count when 2 conditions are present from a referenced smartsheet. This is the formula I created according to the guides I can find, but smartsheet says it is unparsable. Can someone let me know what the error is?
=COUNTIFS({Range 3}, "Current", {Range 2}, "Critical")
Answers
-
Hi @Debalfa
I hope you're well and safe!
What column types are the ranges referencing?
Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
This is a screen shot of the 3 text fields I am trying to count the various pivots of how many of items in the Severity Column by value are in the Report Status column values various buckets. Thank you in advance for your assistance. The end result should show me # of Resolved items in the High Severity, # of Resolved items in the Medium Severity, etc.
-
Are you able to provide a screenshot of the formula actually in the sheet similar to the screenshot below?
-
This is a screen shot of the formula I wrote in Smartsheet, but I get an error.
-
Which error exactly are you getting with the above?
-
I got the formula to work. The issue was the ranges I was referencing were not being updated. I redid the formula and now it looks like it is picking up both criteria. Thank you so much for the help!
-
Glad you were able to get it working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 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!