Hi, I am looking for help as i am struggling to work out why a nested formula will built isn’t working for one login but not the other within our tea, despite it being the same and all the tags, fields etc being mirrored.
We are trying to categorise our database into - Gold, Silver, Bronze and have used the formula below which works for my analyst, but not for me. Can anyone help me understand why it isn’t working on mine
My guess is that you might have the time enabled for your “Last Catchup” date field, in which case it’s probably a time zone issue for your “Last Catchup” field. I think you can solve the problem by disabling the time.
But if you keep the time enabled, you’ll likely want to make sure that the time zone is evaluated as the exact same time zone for everyone, no matter where they’re logging in from. To do that, you’ll need to change that “Last Catchup” field to be in the GMT time zone (which is on the formatting tab of the field customization screen for that field). If you don’t choose that option, the time zone gets evaluated fo everybody’s local time zone.
However, after you enable GMT, then you’ll have another problem, because the TODAY() function in your formula is only going to evaluate as your local time zone (which is probably not GMT time zone)… unless you set it to a certain time zone using the SET_TIMEZONE function.
For a deeper dive into time zones, you can check out my sample base and training video located here:
Thanks very much for the follow up. I have re-checked and both myself and my team member have everything set-up exactly the same. As such the explanation above doesn’t really work as it would mean completely reworking the formula, which works for them