How to save Ref column to spreadsheet correctly?

[Michael_057]

How to save Ref column to spreadsheet correctly?

[JMPeterson]

Ref type columns use the unique ID to reference in the associated data. As long as you maintain the Ref column type, everything will appear correctly in the app. 

If you want to save the actual 'Name', you'll need to use a different method like using a SELECT() statement.

[Suvrutt_Gurjar]

---

@JMPeterson wrote:

If you want to save the actual 'Name', you'll need to use a different method like using a SELECT() statement.

---

Or use dereference expressions 

https://support.google.com/appsheet/answer/10107396?hl=en