Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hello community.
Wondering if there is the capability of capturing "time" in forms and sheets. I would like field engineers to log what time they arrived on site, then left via a Time field. I would then like the master sheet to calculate time spent on site.
Any ideas?
Thanks
Stuart
I could not get in the 101 training yesterday. My system said Blocked. Is the training part of UTube?
Thanks,
Diane
Hi Stuart, while you can set task durations in time (down to the second) and perform calculations off this data, there isnt a built in method to display start and and times for tasks, although you can display this manually in a Text/Number column.
A time column is somehting our Product team is looking into for future releases and I will add your vote for it.
Diane, here's a link to the Smartsheet 101 webinar: https://www.youtube.com/watch?v=w7BYs1O_XbU
If you are having trouble accessing future webinars, email training@smartsheet.com
Here is an exmple I am working on for client time tracking for billing purposes.
This is a webform that populates a tab, where I have a formula to calculate the hours and minutes together. https://app.smartsheet.com/b/form?EQBCT=08ba987910cd4ffc91228f1844514713
You can do something very similar and give users and easy way to enter tasks and time.
Here is what the end result would look like. I will leave this public for a week or so and then remove. http://publish.smartsheet.com/a8b61bfd66f64e92b192b308a6693dd2
Chuck, if you only want to show duration, you can enable dependencies and use the duration column. It can track weeks, days, hours, minutes, and seconds (and any combination of those).
This would require a start and end date column in your sheet, but the end date column can be hidden if you do not need it.
User can add a start date and duration in web form, just use the first letting of the duration type:
1w = week
1h = hour
1m = minute
1s = second
