I am trying to create a quiz, and in the sheet, I have three columns, one for Answer, one for Correct Answer, and one for Result. Initially, the Answer column will be blank, as user has not selected an answer, the Correct answer will have the correct answer value, and the Result column will show Tr…

Use a template column in Glide data editor to set the response (or use a gsheet column, no matter). Then add an if/then/else column in data editor with the following : if response is empty then empty else “answer column”. And in your app, the answer will be displayed using the if/then/else column. …

I am sorry I am not able to understand your approach. If I use the IF-THEN-ELSE column in data editor, is this what I use? If Answer is empty, then Result is Empty Else Result = Answer? Is that what you are suggesting?

The if/then/else column will be populated as follow : if answer is empty then “empty” (null value) else “value of the result column” (true or false) And your result column will also be an if/then/else column : if answer is empty then empty And if answer equals correct answer then TRUE else FALSE

How do i check if Answer equals Correct Answer using the If-Then-Else column. Because, I dont see an option to compare two columns, it only compares a column with a value we need to enter. [image]

[image] Manan_Mehta: =arrayformula(IF(LEN(G2:G)=0,“”,if(G2:G=H2:H,TRUE,FALSE))) That worked! Thank you very much! :heart_eyes:

Try this nested formula in Sheets: IF(IF(len(A2:A)=0,"",G2:G=H2:H)=FALSE,"",IF(len(A2:A)=0,"",G2:G=H2:H))

Thanks for helping. I already got the answer.as mentioned above.

Formula to calculate only if a cell has value, else to be blank

Ask for Help

Manan_Mehta March 9, 2020, 7:03am 6

Try this formula instead
=arrayformula(IF(LEN(G2:G)=0,"",if(G2:G=H2:H,TRUE,FALSE)))

Topic		Replies	Views
Help with Arrayformula If is Blank Ask for Help	8	511	December 21, 2020
If→Then→Else column with multiple criteria Ask for Help	4	83	July 12, 2025
Empty Boolean field issue Report a Bug	10	583	August 23, 2020
ArrayFormula to apply checklist cell Ask for Help	7	457	July 25, 2020
Dataeditor: average calculation on non empty cells? Ask for Help	8	552	August 13, 2020

Formula to calculate only if a cell has value, else to be blank

Related topics