This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Ref type is adding an apostrophe in my google sheet column

Posted on 02-19-2020 10:30 AM
Mike_T
New Member
Reply posted on --/--/---- --:-- AM

User selects a name from a reference list, the form returns the IDKey to the google sheet. If the ID key is a number an apostrophe is being added to the beginning of the ID Key. I’m trying to reference this value with a google sheet formula but it doesn’t recognize it when there is a leading apostrophe. Any ideas?

Solved Solved
0 5 1,425
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
GreenFlux
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

This might have something to do with the column’s formatting in Google Sheets (not an AppSheet setting).

Try selecting the column in Google Sheets and setting Format>Number to Plain Text.

View solution in original post

Jump to Solution
5 REPLIES 5
Top Labels in this Space