Days without incident counter

Amanda MedinaIW

Hello,

I would like to put a Days Without Incident counter on my dashboard.

I would like to count the days from the last incident (RED bubble in the Risk column) to today.

KPH

Hi @Amanda MedinaIW

@DKazatsky2 's formula works on each row and would give you days since the Date of Incident. Like this:

It sounds like you might want the number of days since the most recent incident and also only want to count the days since the Red risk. You could do this if you sort the sheet and look at the row that is most recent and red. Or you can do this with a longer formula.

For that there is an extra step. You will also need this formula

=MAX(COLLECT([Date of Incident]:[Date of Incident], Risk:Risk, "Red"))

This will find the most recent Date of Incident in the list, where the Risk is Red.

If you combine that with Dave's formula (replacing the cell reference with this new formula), you have:

=TODAY() - MAX(COLLECT([Date of Incident]:[Date of Incident], Risk:Risk, "Red"))

This is today's date minus the most recent date where the risk was red, in days.

#TeamWorkMakesTheDreamWork

DKazatsky2

Hi @Amanda MedinaIW,

Try this.

=TODAY() - [Date of Incident]@row

Hope this helps,

Dave

KPH

Hi @Amanda MedinaIW

@DKazatsky2 's formula works on each row and would give you days since the Date of Incident. Like this:

It sounds like you might want the number of days since the most recent incident and also only want to count the days since the Red risk. You could do this if you sort the sheet and look at the row that is most recent and red. Or you can do this with a longer formula.

For that there is an extra step. You will also need this formula

=MAX(COLLECT([Date of Incident]:[Date of Incident], Risk:Risk, "Red"))

This will find the most recent Date of Incident in the list, where the Risk is Red.

If you combine that with Dave's formula (replacing the cell reference with this new formula), you have:

=TODAY() - MAX(COLLECT([Date of Incident]:[Date of Incident], Risk:Risk, "Red"))

This is today's date minus the most recent date where the risk was red, in days.

#TeamWorkMakesTheDreamWork

Amanda MedinaIW

Thank you! This worked perfectly!

KPH

Great news @Amanda MedinaIW !