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.