Display header rows only if there are additional rows on the same date

samcotton

I'm building out a production schedule and am looking to create a formula that would help me only display a header row (grey) if there's an associated line item on that same date (white). Ideally, this would hide Saturday 6 April and Sunday 7 April (until/unless we add an item on that date at a later time. Is that possible? Thank you!

AravindGP

Hi @samcotton,

You can create a helper column to identify if the date appears multiple times and use that as the filter in your report. The formula to use is =IF(COUNTIF([Start Date]:[Start Date], [Start Date]@row) > 1, 1, 0)

Your report might look like this