Countifs and Contains (Name & Date)


Hello All!

A bit of a tricky one here - I am trying to COUNT the amount of times a person has an item for each month. The problem is when I use CONTAINS and select the month it shows anywhere that number shows.

For example, I am trying to find each time a person has something with a date of anytime in August (8).. when I use 8 it collects other dates like 7/08/20 but I don't want JULY I only want August.

Any thoughts?!?

=COUNTIFS({Name}, Name@row, {Lease Move in Log Range 1}, FIND("8", @cell) > 0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!