nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Tracking time in forms

BESP10

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

Created Date Time Stamp
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
How to auto populate cells
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Why Can't I no Longer Able to add Folders, Sheets, or Reports in my "Sheets" folder
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…