Formula field: Incorrect time value (seems like in a different timezone)

Bugs & Issues
1

Hi there! In my CRM I have 3 dbs: Activity, Contact, Contact Engagement

In Contact Engagement I have a formula field “Last Activity” referencing the latest contact activity. However, in Contact Engagement db time is shown seems like in a different timezone - the UTC+0 one?

image
image1590×949 135 KB

image
image562×299 4.25 KB

image
image610×518 24.9 KB

2
3

Thanks for this. But it’s still not clear to me why it shows UTC as all I do in Last Activity formula field is referencing the existing field value (Last Activity DT) in the other db. What would be the elegant solution for my case without the need to “hard code” the time difference?

4

Conversion to text happens server side, so is in UTC

5

I got this - it was in the Guide. What could be a client-side solution without the need for hard-coding the values?

6

There are no client-side formulas I’m afraid.
We do plan to introduce a ‘workspace timezone’ so that server side calculations can be in the timezone of your choice.
But if you have users across different timezones, they won’t all see the result adjusted to their zone - a text formula field value cannot vary from person to person.

7

Yeah, the workspace timezone/locale would be awesome. I wonder how do they manage the distributed teams support in Notion and other apps when it comes to different timezones per user?..