How to add a Red Flag when there is an entry more than once in last 12 months
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
-
=IF(COUNTIFS(Driver:Driver, Driver@row@row, [Offence Date]:[Offence Date], @cell > TODAY(-365)) > 1, 1)
Give that a try and see if it fits what you need.
-
Got #UNPARSEABLE as a result unfortunately Paul.
I deleted the double up of @row and then it worked fine.
Many Thanks again Paul
Regards
Steve
-
I'm not sure how I got that extra @row in there. Sorry about that. Glad you were able to get it figured out.
-
Was sheer luck on my part lol. The not being highligted like the one next to it gave it away.
-
At least one of us was paying attention. Lol!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!