Question about hiding rows so they do not come though onto a dashboard

Hi there,

As per the image below I have columns that display the month from Left to Right. I am looking to hide the months closest to the primary column as they are now in the past - but want to copy the primary column as is displays the metrics on my dashboard. Can I simply hide the rows I don't want or is there another solution??

Any help would be amazing




  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭

    Hello @Trav25,

    If you want you can hide the columns and it will not affect any calculations.


    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭

    Hi @Trav25

    I would create a report for this information and display the report on the dashboard. While you could publish the sheet and display that on the dashboard, the report is the safer way to go.

    I hope that helps.


    Matt Johnson

    Sevan Technology

    Smartsheet PLATINUM Partner