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

(Ellen Sligh) #1

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?

(Levent KULAÇOĞLU) #2

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