Tracking time in forms

Good afternoon,

We are creating a form/sheet to track our deliveries to job sites. We want our driver to be able to log the time he arrives on site and the time he leaves. Is there a time feature we can use for forms?

Thanks

Find more posts tagged with

Forms

Templates

Construction

Comments

Mike Wilday

There is not currently a time or duration formula in Smartsheets. You can track the time by having him input the time, but there is not a lot of calculation possibilities with it yet. There are rumors of smartsheet adding that functionality. But then, there are a lot of other rumors about smartsheet too that I haven't seen come to fruition.

Mike Wilday

Please submit a product enhancement request.

Andrée Starå

Hi,

One way I solved a similar request with clients is to have pre-defined time slots and they can register start time / end time or multiple different times if there's a need.

Would that work?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

BESP10

we are going to try this route. Thank you !

Andrée Starå

Great!

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
Make Rows From "Active Projects" Sheet Transfer to Another Sheet ("Invoicing") Upon Job Completion
My company uses Smartsheet on an extremely rudimentary level. We are not tech savvy; we are tragically behind. We have only figured out to use one automation so far, which is when a new cabinet-related "project" gets automatically added to our "Active Projects" sheet from our "Sales Pipeline" sheet. But we have a major…
Smartsheet Help
Hi Smartsheet community! I am looking for guidance on best approach to create an individual tactical plan w/ embedded milestones and general timeline that rolls up into a Team tactical plan w/ milestones/timeline. Hoping for functionality where individuals are notified a milestone dates and progress to goal is tracked at…