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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!