Innerjoin causing date and multiselect coloumns to not display in desired format


I am using Innerjoin between two tables, but Date coloumn and multiselect coloumn looses its formatting.

For Comparision, I have another trable grid control accessing the same information through simple Lookup.

Notice the difference in the representation of NextFUD and Product Category Colomns

Please guide

Hi @yash1,

Yes, tablegrid automagically formats the LOOKUP Keys based on Sheet’s Column type but in case of INNERJOIN of 2 Sheets it looses this capability.

For such cases, as a workaround currently, it is recommended to add a Formula Column in the Sheet instead and use that column instead of Date Column when merging Multiple Sheets.

Hope this Helps!