How to add a Red Flag when there is an entry more than once in last 12 months

Steve Moss
edited 12/09/19 in Formulas and Functions


I have a table which records driving infringements.

What I want to be able to do is have a function determine if a driver has had more than one infringement in the last 12 months.


Then use the Actions and Alerts to notify their manager. But need the function to work first before I can do that. I know how to use the Action and Alerts now. Just need help on the function.


I am using these columns to do this:

[Offence Date], [Driver], [Flagged]



Flagged is already set to the red or blank flag.

But I want to do this automatically.

How can I achieve this?


Kind Regards




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!