Can I use dynamic values as column headers?

I've created a dashboard utilizing data from one of my sheets. I'd like to show eight weeks of historical data to establish a trend, which I have sorted out, but I'd like the values in the chart to show dynamic dates instead of static week numbers. Can this be done and what would be the technique I can use? Thanks in advance for any help!


  • Hi @jharrison225

    Using a checkbox to include information is the report is the approach I use.

    I uncheck those I don't want in the report and so those date should pull though?



  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @jharrison225

    Column names are static, so if your sheet is set up with the column titles being the week numbers then there currently isn't a way to adjust what is shown in your report or chart. The week numbers or dates would need to be down a row instead of in a column.

    If you'd like some help with this, it would be useful to see screen captures of your set up, but please either use test/example data or block out anything sensitive.