Count Function Error

Robin Johnson
Robin Johnson ✭✭
edited 01/04/24 in Formulas and Functions

Trying to count the number of times there was Giving before 01/01/24. Using the function shown, it yields 0. If I change < to show count after 01/01/24, it gives me 9 instead of 2. What am I doing wrong?

Thanks for your response.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!