Hi folks,
I’ve got a board to track episode recordings for a podcast between two hosts who are often on the road. I’ve got a date/time column to specify the recording time for each episode, and two location columns to specify where each host will be located on that day. I’d like to create two hour columns that will automatically display the local time and timezone code of the episode recording for each host based on their location.
Unfortunately, neither Automations nor Formulas currently seem to support location column values as a variable, and Monday AI doesn’t seem able to read the time in Date/Time columns properly: It simply prints the visible time (for me, in ET) and puts the wrong timezone code after it.
Any ideas for how to work around these limitations?