I have a field called “Power Tag” that is configured as a Yes/No field. If the user selects Yes, I want to store the string “PTPresent” in the spreadsheet. If the user selects No, I want to store the string “PTAbsent” in the spreadsheet. I like the simplicity in the UI of the Yes/No toggle rather than a drop list with PTPresent and PTAbsent in the list values. But when it comes time to send the data to the customer, the simple Yes/No in the data doesn’t make as much sense as the more descriptive text. Is there any way to convert the Yes/No to the text (and back) without using additional columns in the spreadsheet along with Excel formulas?
LinkedIn
Twitter
