sanantonio
Board Regular
- Joined
- Oct 26, 2021
- Messages
- 124
- Office Version
- 365
- Platform
- Windows
Hi All
I have a reference table on "Leaflet Zones" are sites are in. It's a one with an added measure to display all text separated by a comma. It looks like:
When I am then referencing that pivot table...
You can see the formula it brings up. When I try to change the "1001" to instead be a cell reference, L3 it just gives me #Ref. I've tried text(L3,0) and that doesn't work either. Only manually entering the code with the [] seems to work.
What am I missing to make that work?
Thanks in advance.
I have a reference table on "Leaflet Zones" are sites are in. It's a one with an added measure to display all text separated by a comma. It looks like:
When I am then referencing that pivot table...
You can see the formula it brings up. When I try to change the "1001" to instead be a cell reference, L3 it just gives me #Ref. I've tried text(L3,0) and that doesn't work either. Only manually entering the code with the [] seems to work.
What am I missing to make that work?
Thanks in advance.