Formula Assistance

CaraBart28

I am trying to identify how many times over the year a report was either received on time, late, or not at all. The reports are due to be received by the end of each month. The first attachment is the sheet which is being referenced. The report name being listed down the left side, and then identifying the date each month in which that months report was received. The second attachment is where I am trying to create the formula. Ultimately I would like to be able to display this information on a dashboard.

CaraBart28

Hi @Andrée Starå Thank you for responding, I was able to figure it out by adding in helper columns!

Andrée Starå

Hi @CaraBart28

I hope you're well and safe!

Do you need to check the current year only or rolling 12 months?

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

CaraBart28

Hi @Andrée Starå Thank you for responding, I was able to figure it out by adding in helper columns!

Andrée Starå

@CaraBart28

Happy to help!

Excellent! Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!