Hello everyone, first of all I have to say my knowledge of english is not exactly perfect, and I am sorry for it but I hope youโll understand. I want that my app shows, for some columns, a different text from the one itโs written in the Google Sheet. Letโs say I want my text from [Column1] to be replaced with โOKโ when I write โYesโ in the Google Sheet. I tried putting as a formula for column [Column1] the following formula:
SUBSTITUTE([Column1], โYesโ, โOKโ)
It doesnโt give me errors, but when I try to open the app, unfortunately, I see โYesโ written and not โOKโ.
Thanks in advance for your help!
Why not just change the value thatโs being set in the column to what you want?
Unless you create a VC to โtransformโ the data from the sheet into something else, any data will be represented as it is in the source when viewed inside your app.
A will be A
B will be B
If you want A to say Apple, then youโll need to create a new place to make this alteration - either a virtual column or another physical column.
I used virtual columns and it worked!
Thank you!
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |