Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

How to stop column dereferences from including table name

I have Table A using dereference formulas in five columns. All work as intended, except for one which is adding the table name in front of each cell value.

The only thing unique about this column is that it’s an image column type whereas the others are text column types. For example, the image name in Table B is ‘01003.jpeg’ and when it’s copied to Table A it’s showing up as ‘Table B:: 01003.jpeg’.

Does anyone know why that’s happening and how to have it only copy the filename over? FYI The image is in the same folder as my google sheet so the table name isn’t necessary.

0 5 231
5 REPLIES 5
Top Labels in this Space