Compare dates in a column and return a value if match in another column


There are two columns that I need to count and match:

  • Date of Purchase
  • Lead Tech

Here is what I need the formula to do:

  • If there is a name that appears more than once in the Lead Tech column, then:
  • Count the number of times they appear in the last 7 days and last 30 days using the Date of Purchase column.
  • Return a value of the number of times.

Thank you in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!