How to add few texts/words on countif(s) formula

Hi, can someone help me on the correct formula that I should use? I wanted to get the number of projects based on their status however the countif formula that I am trying to use doesn't work in Smarsheet but works in Excel.
Below is the formula I used in Excel that worked:
=COUNTIFS(B3:B11,"*contract for*",C3:C11,"=active",D3:D11,"delayed")
I tried an alternative solution by using the project owner names but I only want to count the cells that are not blank.
Alternative formula I used in Smartsheet:
=COUNTIF([Project Owner]:[Project Owner], "<>", Status:Status, "complete")
Please need your comments and suggestions.
Many thanks in advance,
Grace
Comments
-
Hi Grace,
Smartsheet's search operators are less than perfect and nowhere near what you're used to in Excel.
Will this do what you need?
=COUNTIFS([Project Owner]:[Project Owner], NOT(ISBLANK(@cell)), Status:Status, "Complete")
-
Hi Chris,
The formula worked! Thanks a lot for your help.
Cheers,
Grace
-
Happy I could help out Grace.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!