COUNTIF Function

Matt Wood
Matt Wood ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi All,


I'm looking for assistance with COUNTIF if possible. I have a smartsheet containing 3 Rows of multiple flight departures.

I need to create new columns which will count the following cells for me:


Departure Flight Number

Departure Date

Flight Arrival Time


All of the cells are completed, however when using COUNTIF, I cannot get it to count. I've copied the sheet into Excel and worked for the formula as required there so unsure why I cannot get it work in SS.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!