Showing the start/end date in a project plan in multiple time zones

Karen Stulc

Hi,

I am developing a project plan for a global team. I have built a project plan that shows the start and end times in PST but other team members would like to see when a task is going to be triggered in their local time zone.

In MS Project I was able to create a column that showed the date/time plus 9 hours for CET, for example.

I have used a formula to display the underlying hour/minute for a task but can't seem to find a way to add hours, only days.

this is what I have so far:

I want to add more columns to show the start date/time and end date/time in CET.

Note that the Start Date/Time PST is now a text field since I used a formula to show it. Whatever calculation I use, will have to start from the Start Date PST. For example if I use =[Start Date PST]+1 would show April 23, not April 22 12 PM.

Thanks in advance for your help.

Karen

Alejandra

Hi @Karen Stulc,

I don't think this is currently possible since Smartsheet doesn't have a time function. For example, even if you were to split the date and time up into separate columns adding a 1 to the cell containing 11:00 AM results in 11:00 AM1.

When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.