How do I create a report that displays rows that are passed a certain set date for each row?

I'm attempting to create a report that easily displays rows that are delayed. For example, if I had a planned delivery date of 08/07/2024 (UK Format), but this was actually delivered on 10/07/2024 (UK Format), I would like the report to only display this row.

If the planned delivery date of 08/07/2024 (UK Format) was met, or delivered beforehand, I wouldn't expect this to be displayed.

Any info would be greatly appreciated!

Best Answer

  • Protonsponge
    Protonsponge ✭✭✭✭✭✭
    Answer ✓

    Hello @Christopher Nash

    Could you have a check box helper column to tick rows where the delivery date is greater than that planned delivery date using a formula as per below. If you set this to a column formula you can always hide it if you dont want to see it.

    =IF([Actual Delivery Date]@row > [Planned Delivery Date]@row, 1, 0)

    In your report, you could then filter by [Delayed Delivery Check] is checked as per below.

    I hope that is helpful to you in someway,

    Protonsponge

Answers