Different timezones and the today function

Wini

So, in one of the sheets we are working on, the date for the today function always changes back and forth (a day difference). We think it's because a member of the team has a different timezone so whenever they make changes to the sheet, not relating to the today functions, it changes. We think this because whenever one of the members in our timezone updates the sheet, the date goes back to the right date. Is there a way to make the timezone fixed for the sheet or just make it so that it shows the correct date for both side and stop changing.

Thanks!

Peter Harink

Hi Wini,

Unfortunately this is a known issue we also have been struggling with a couple of times. It can be another user, but it can also for example be caused by user cell-link@smartsheet.com when you are using linked cells in the sheet.

As far as we have found out it is not possible to define a fixed timezone for a sheet or workspace. We had to solve it in these cases by using a summary field which is updated automatically through the API and set to the correct date value instead of using the TODAY function.

Kind regards,

Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl

Peter Harink

PS you could off course check the cell history (via right mouse click "view cell history") or look into the "Activity log" and see what exactly causes this behavior

Peter Harink

Hi Wini,

Unfortunately this is a known issue we also have been struggling with a couple of times. It can be another user, but it can also for example be caused by user cell-link@smartsheet.com when you are using linked cells in the sheet.

As far as we have found out it is not possible to define a fixed timezone for a sheet or workspace. We had to solve it in these cases by using a summary field which is updated automatically through the API and set to the correct date value instead of using the TODAY function.

Kind regards,

Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl

Peter Harink

PS you could off course check the cell history (via right mouse click "view cell history") or look into the "Activity log" and see what exactly causes this behavior

Wini

Hi Peter,

I think it is by user cell-link@smartsheet.com and I had no idea what this means. Can you elaborate on how you fixed it please?

Thank you so much for your help!

Peter Harink

Hi Wini,

We fixed this with a process running in the cloud and updating just once every day the date. (we've built a small program which uses the Smartsheet API for this)

If you need any help on that just send me an email.

Kind regards,

Peter Harink | 4EF.nl | Consultant & Managing Partner | peter.harink@4ef.nl