IF formula formatting for grouping

Topic Labels: Formulas
538 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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:

Screen Shot 2021-01-27 at 12.08.41 PM

And this is how it’s grouping:
Screen Shot 2021-01-27 at 1.05.26 PM

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!

1 Reply 1

If you’re grabbing a value from a lookup field, you need to concatenate that value with an empty string in order to turn the lookup value into a string.

So, for example, if your Lookup Field is called “Lookup Field”, when you pull a value from it, reference it like this:

{Lookup Field} & ""