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

Hi,

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]

 

Note:

Flagged is already set to the red or blank flag.

But I want to do this automatically.

How can I achieve this?

 

Kind Regards

 

Steve

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!