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
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
