Have a boolean column to show whether a date is ‘today’. The timestamp column that it references is today in one of the rows but the boolean is not checked. Timezone settings in the sheet and PC are set to local time. Seems to work from about 9:00 am but not before.
I swear there’s a bug somewhere but can’t put my finger on it. In the past I’ve seen Now in a Math column return a date and time that is several hours off.