Solved: If any respond is false between regarding columns,... - Page 2

questionmarkdev · 01-23-2021 03:13 AM

I am searching formula of appsheet like excel formula

Imagine that there is survey with yes or no answers. When the questions are selected yes or no, the point will change after every yes selecting.

How do i write formula under “result” column such as excel formula =IFS(COUNTIF(D2:G2,“FALSE)>0”,“FAIL”,“Do something for every yes answers”)

if there is “false” between regarding columns, the result will display automatically “FAIL”. Otherwise, the all true answer’s point will be 10. Image that there are 50 columns, and if there is even 1 no answer at first 10 columns, the result will be “FAİL”. If there is no any no answer first 10 columns, every yes answer will be 10 point. If there is “no answers” between 11 - 50 columns. Every yes answer will be 10 point.

questionmarkdev

i think, to put 0 instead of FAIL is sensible as you said

I tried it as
IF(NOT(AND([IŞIKLAR-Farlar çalışıyor mu?];[IŞIKLAR-Yan ışıklar çalışıyor mu?])), 0; IFS([IŞIKLAR-Farlar çalışıyor mu?],20)+ IFS([IŞIKLAR-Yan ışıklar çalışıyor mu?],20))
This is solution.

View solution in original post

If any respond is false between regarding columns, result will be "FAIL"