So I created a SELECT list virtual column to ...

So I created a SELECT list virtual column to list names into different rows.

It works great as a virtual column for my app but I really want it to appear in my data sheet so Iโ€™ve been trying to do a textjoin query array but nothing works.

So does anyone know how to make the values showing in my virtual column to appear in my data sheet?

0 1 332
1 REPLY 1

@Ellen_Sligh1 you can add a physical column to your sheet and set its AppFormula property to [_THISROW].[VirtualColumnName]

Top Labels in this Space