I'm working on App Sheet that has data source from Google Sheets.
I am trying to put together a formula that looks at several different possible values:
What I want:
If Answer = "Yes" then 100
If Answer = "No" then 0
If Answer = "N/A" then I want it to be blank
I put this as my formula which I know would be right if it's in Excel
IF([Answer]="Yes",100, IF([Answer]="No",0,""))
for the "Yes" and "No" it works but for "N/A" it won't leave the cell blank, instead it would return as 0. Maybe I got the column type wrong? I tried Decimal and Number, but it doesn't work, I tried Text it works -- the cell becomes blank, but it reads as text so my other formula that reference to that cell doesn't work.
LinkedIn
Twitter
