Hi all - I’m having an issue when I try to “group by” a formula column in my spreadsheet. The issue is that it’s formatting the same date in two different ways and then treating the same date as different items and therefore splitting the group into two.
This is how it’s formatting:
And this is how it’s grouping:
That should be one group of 57 entries.
The formula is an IF formula that grabs a time from one of two columns. One column is a lookup, and the other is a date column. Is there any way to make sure they’re formatted the same way when they come out of the IF formula?
Thanks in advance!