Help Using COUNTIF with CONTAINS and the status column
Hi!
I figured out the formula to count the row from another sheet if the cell contains a certain word, =COUNTIF({Current Project List Range 2}, CONTAINS("Events", @cell))
However this counts all the items regardless of Status. I'd like to get it to count only if the Status Column is also showing "In Progress" or "Not Started".
Thank you!
Answers
-
Hi Len,
Would the COUNTIFS function work for you?
Others have also tried nesting AND and OR functions with varying degrees of success.
Hope this helps?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
-
Thank you for your response Jason! Do you have an example of how I would use the AND function? Every time I've tried, I get an #UNPARSEABLE error.
-
Hi Len,
In regard to your original question I personally would gravitate to the COUNTIFS (not the COUNTIF) function. The "S" on the end makes all the difference.
In regard to the AND function, Smartsheet has a writeup here. You'll note the example only uses the IF function.
There are also some good examples via the second link in my first response.
Maybe share with us an example of your #UNPARSEABLE formula for the community to help you out?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!