Count if + Contains?


I have a column of dates. My data sometimes will give a "fake date" of 01/01/01. I'm trying to have that specific date counted. My formula is:

=COUNTIFS({FLEETCARE UPLOAD Range 2}, CONTAINS("01/01/01", @cell))

But it doesn't seem to be working?

Any ideas?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!