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
-
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
-
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
-
-
Great, pleased you got something that worked for you.
I'm grateful for the opportunity to help you out,
Protonsponge
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives