Hey @jappleii
Can you provide more details for what you're looking to do? The Time Function can reference one Text/Number time cell and add hours on to that time to display a different timezone in another column, if that's what you're looking for?
Keep in mind the System Date columns (Created and Modified) will display time based on the user's timezone set in their Personal Settings, if that helps.
I agree with these posts - Smartsheet is already calculating time in hours for duration - seems to me that would be the tough part of coding! Now you just need to display it. I would vote for formatting the Date columns to include hours and minutes so that you can see the time a task is scheduled to start and end.
the ability to track time/duration in a HH:MM:SS format would be so handy for a lot of media organisations for things like slate management, production management, scheduling etc.
Another vote for a Time Column - Would take Smartsheet to the next level. Timesheets, Sign in / Out registers etc.
@Genevieve P. I apologize, I had a new member enter my family and lost track of everything.
So, this seems to link to the documentation that the SmartSheets system currently seems to save the timesheet's timezone as whatever user last saved the sheet (which is what I found in the SmartSheet documentation). So, let me give you a very realistic hypothetical for my team:
----------------------
We have an event in Vietnam in 2 months, for which we're planning to run backend setup and operations. Our PM's are in Australia, Egypt, and Texas and all 3 are working to coordinate this project with support teams in each region.
For 4 timeslots each day, we will be running 4 rooms of labs per timeslot, for each day. This equals 16 separate setup, run, teardown tasks per day. Our operations teams are in Australia, India, Austria, Portugal, Iowa, and Utah - round the clock, and each team has work to do, and sometimes they need to cover for one another.
In our planning, we have setup, run, and teardown tasks that will be planned according to Vietnam's timezone due to the event, but each PM is coordinating a separate stream of work that applies to when setup needs to run for each room and the organizer/speaker in that room, and assigning it to the operation team that has that task land during their business-day, and how early thethe speaker/organizer(s) need to run through prep on their environment(s) based on what they are doing, and that work needs to be coordinated across.
Onsite at the event we will have a single coordinator PM who will then make sure the tasks that need execution are executed on that specific time and will be running early/late calls with each operations team to ensure setup/teardown are completed on-time according to the needs.
So, that's the use-case.
----------------------
What do I need in order to realistically use SmartSheets for this?
At this point in time, I can't use Smartsheet for that, so we're back to Google Spreadsheets again.
Does this help explain what I'm requesting?
@jappleii The user's location is easy since that is tied to their personal settings and picking the correct Time zone. This will adjust all system times for that user (Last modified and created dates and times)
As for documenting additional time in a cell, you can do this with Bridge. I had a solution where we needed to capture the exact time due to SLA agreements for response times etc. Basically Location 1 = Time zone 1 and Location 2 = Time zone 2 and so on.
Here is some info on bridge https://www.smartsheet.com/platform/bridge Hope this helps! Let me know if you would like to get on a call to discuss more.
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
Hi, @Joe Goetschel,
I took a look at Bridge - but it's far beyond what I need. According to the SmartSheet documentation I read, the Smartsheet document itself adjusts to match the Timezone of the last EDITOR of the sheet. Which means our PM's in APAC, EMEA, and NA will constantly nuke the intended timezone. That's not going to work.
All I really need is the ability to set a Timezone, with a variable or function that lets me adjust the time to the user's local timezone. And I can't do that currently - I've tested the existing system with my teammates in Australia, India, Europe, US East/Central/West, and Canada, and the systems doesn't handle it because of the current limitations.
Thus why I'm back to spreadsheets again instead of SmartSheets. :(
@jappleii I had an idea and I have validated it works.
You get a baseline time column that will house the current time ( any zone you want) I used Zapier to do this.
You then use the Time Function to set other columns to translate the time to whatever you choose.
Now that you have the time zones, you can live in reports and only choose the timezone you wish etc.
Let me know if you would like help setting this up, my email is below!
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."