Workflow or function that alerts me when something repeats

I would like to set up an automation or function that alerts me when something is repeated in a sheet 3 times in a 30-day period. The trigger could be taken from a drop down menu, i.e the location "ABC Lane" has been chosen in a row from the drop down on 06/01, 06/05, and 06/21" . I do not see something like this in the automation field and I am unsure if there is a formula/function that could accomplish this.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!