im using DEREFERENCE to populate information ...

im using DEREFERENCE to populate information from SHEET1 to SHEET2, but it seems that when I make a change to the information to SHEET1 it doesn’t change and reflect on SHEET2.

is there an alternative to REFERENCE to solve this issue?

thank you;

0 1 394
1 REPLY 1

tony1
Participant V

@Francisco_Martinez It sounds like you should be using your dereference formula in a virtual column instead of a non-virtual column.

https://help.appsheet.com/data/columns/virtual-columns

Top Labels in this Space