Hourly view on Gantt View

Answered - Pending Review

Hi there,

We have a project with vehicles moving across multiple locations and would like to keep tract of their activity by the hour. We don't so much need to track their GPS location as much as, Car # 1 is in Town A, and then needs to go to Town B for 2 hours, then return to Town A. Gantt view would be very effective for this if it were available on an hourly basis? What would be a good way to visually track within a day?

Thank you,



  • Hey @Esperanza Zagal

    So as you may have seen, we don't have a Time feature by default. With this, please feel free to raise an Enhancement Request using the Hamburger Menu (3 horizontal lines) in the top left of this page! 😀

    Contrary to this, I was able to find a Community Forum with a long list of Time based Formulas that you may want to review and implement into a Sheet. This user has also provided Example Sheets so their construction can be seen: https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time/p1

    Please let me know if you have any questions.

    Kindest Regards


Sign In or Register to comment.