@Kaushal_Didwani wrote:
Is there any way to put the label value in google sheets?
Yes, change the column from REF to the appropriate data type and then use an expression to retrieve the actual value you want. But beware doing this....
The purpose of a REF column is to provide a "pointer" to a specific table row for two reasons
- so the app can have access to all the column values of that row.
- if a specific column value should change, the table row retrieving the value will automatically be updated
For this to work, AppSheet will always record the "pointer", AKA row key, as the column value of a REF column. You have control by the Row Label setting as to which value is displayed instead of the pointer but that is only used in the app views.
If you do not need to gain access to other column values OR do not care about getting an updated value should it be changed in the source table, then you can safely change the column from REF type to the other type and simply use an expression to get the value. LOOKUP() can help with this.
LinkedIn
Twitter
