How do I count an occurrence when two dates don't match?


Can someone help me create a formula that will look at the form created date (date only) and compare it to the activity date being reported and tell me how frequently the activity date is not the same as the created date?

I get invalid operation with the following:

=COUNTIFS({NS FSE}, [FSE Name]@row, {NS entry date} <> {NS Activity Date})

Wondering also how I can use date only since the created date includes time stamp. Right now I created a separate column to remove the time stamp, but it would be awesome if I didn't have to do that.

Many thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!