Duplicate report data, filtering on reports query
I have a sheets that shows jobs due to go into production, there are however different stages to these jobs, therefore it has the same work order number for each of these stages.
When a job reaches a particular status it requires a review by the quality team, I've therefore created a report to show the quality team all the orders that require their review.
However, I want to remove the duplicates and only show the earliest planned start date.
I was thinking a duplicate formula and looking for a specific work centre, but it doesn't quite work.
=IF(AND([Order Number]@row <> "", OR([Work Center]@row = 40412, [Work Center]@row = 40413), COUNTIFS([Order Number]:[Order Number], [Order Number]@row) > 1), "Offline Required", "Offline Not Required")
Am I overthinking this? Is there an easier way? Maybe I can just create a column that looks at the work order and shows the earliest date?
Help Article Resources
Check out the Formula Handbook template!