I have 2 different lookup fields:
- Release1 = lookup individual item release date from another table
- ReleaseMulti = rollup multiple items release date based on condition (if its a multi-item) using MIN(Values)
I then have a formula field:
- RELEASE =
IF(Release1="", ReleaseMulti, Release1)
Without grouping, this RELEASE field appears correct… for example showing 9/30/2020 in several records.
However… if I group by RELEASE, I find that it will split into different groups if the 9/30/2020 is from Release1 vs ReleaseMulti in a different group
This is very problematic.
I know ReleaseMulti is an array value, and on a similar text based field I used &’’ trick I read on these boards which solved that issue. But in this date field adding the &’’ to the end of ReleaseMulti in my formula does not work.
I also tried many combinations of arrayflatten, arraycompact, date parse, datetimeformat, etc… to no avail
Can anyone advise how to get a single date from the ReleaseMulti array and convert it to be the exact same date format as the Release1 so that I can group them together properly?