Having multiple time zones on one sheet


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!