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

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!


Answers

  • AravindGP
    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


    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!