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!

Find more posts tagged with

Reports

Filters

Accepted answers

Protonsponge

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

All comments

Protonsponge

Hello @Christopher Nash

=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

Christopher Nash

Hi @Protonsponge,

This has solved the issue and works wonders! Thank you so much!

Kind regards,

Chris

Protonsponge

Great, pleased you got something that worked for you.

I'm grateful for the opportunity to help you out,

Protonsponge

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.