Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Gantt Chart view for Daily / weekly / monthly Scheduled works

edited 12/09/19 in Archived 2016 Posts

Hi all, We are new to this amazing product.

We have separate 9 sites that have numerous different types of scheduled maitenance required at different times. Is there a clear way of displaying this in a gantt chart or spreadsheet type of format?

example - Daily clean, weekly service, monthly polish, yearly audit.

Thanks in advance.


  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Hi Gecko 

    You will need to make sure your column names are uniform across the constituent sheets but once that is right, you can use Reports to pull all your nine sheets into one Report using selective criteria like next 7 days etc.

    If you havent tried that already then you will see there is a Gantt and a sheet view and they are editable, so effectively become your "To Do" lists. Available on mobile too for your onsite people.  

    Good luck and hope that helps? 



  • Gecko

    Many Thanks Richard, will give that a go. Cheers

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    Gantt charts in Sheets and Reports only go down to the week, not to daily.



This discussion has been closed.