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

edited 12/09/19 in Formulas and Functions
03/27/18 Edited 12/09/19

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,


Dashboard Test.png

Popular Tags:


  • Chris McKayChris McKay ✭✭✭✭✭

    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. smiley



  • Chris McKayChris McKay ✭✭✭✭✭

    Happy I could help out Grace.

Sign In or Register to comment.