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
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.
Comments
-
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?
RichardR
Smarterbiz
-
Many Thanks Richard, will give that a go. Cheers
-
FYI
Gantt charts in Sheets and Reports only go down to the week, not to daily.
Craig
