Sign in to join the conversation:
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
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.
Please submit a product enhancement request.
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
we are going to try this route. Thank you !
Great!
Happy to help!
Andrée
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?