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
Hi, My team uses smartsheet to create and notify our team that a user has opened a ticket. We have noticed that emails that are sent via automations are either extremely delayed (several days in some cases) or not being sent out at all. Has anyone else experienced this? Is this an issue on the servers from the issue…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
