Having multiple time zones on one sheet

jenny124253

Hi there, I work with team members across 3 time zones (CET, IST & EST) so would like to display start and end dates & times for all 3 time zones.

Currently my sheet is set up as follows:

Start Date: normal date column

Start date time CET: formula: =[Start Date]@row + ""

— I have predecessors enabled and after extensive googling this was the only way i could find to display the date & time

End Date: normal date column

End date time CET: formula: =[End Date]@row + ""

I would like to replicate the start and end date CET columns to have the same for IST (CET +3.5hrs) and EST (CET - 6hrs)

Appreciate any help!

Genevieve P.

Hi @jenny124253

You can use the TIME function to do simple calculations with time:

Here's more information: https://help.smartsheet.com/function/time

However I would recommend setting a manual time in the CET column, since the hidden time in Predecessor columns may not reflect the same data for all users accessing the sheet. Here's more information: https://help.smartsheet.com/articles/2482412-how-smartsheet-handles-time-zones

Cheers,

Genevieve