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:
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,
Help Article Resources
Check out the Formula Handbook template!