Hi all
I have a column to capture MEMNAME which is a REF from table USERS.
I have another virtual column (WALLET) to display a value based on the selection from table USERS.
I have the following formula in WALLET :
LOOKUP([MEMNAME],“USERS”,“MEMNAME”, “MEMWALLET”)
The issue I have, is when the value of MEMNAME changes, the value of WALLET does not.
Any guidance would be appreciated.
Thank you
You’re using LOOKUP() wrong.
See also:
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |