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.
Solved! Go to Solution.
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.
This is yes/no survey.
There is result column i will type the code in there.
In a result virtual column :
If(not(and([col1name];[col2name];โฆ[col10name])); โFAILโ; โsomething elseโ)
Result virtual column type is number, how can i operate it with fail which is string and number?
I donโt think that is a virtual column, it looks like a physical column in the file.
If you want to have your result in file, I would use a formula in the excel itself (gsheet in my case) , but then, your result will only be calculated and shown to user only after the sync occurs.
Virtual columns are โliveโ , but not saved in file
Anyway, you could put 0 instead of fail ,make your column work with numbers only first.
Later, the 0 can be made to display a FAIL with a help of another virtual column.
I added now virtual column.
Does it make sense?
IF(NOT(AND([IลIKLAR-Farlar รงalฤฑลฤฑyor mu?];[IลIKLAR-Yan ฤฑลฤฑklar รงalฤฑลฤฑyor mu?])), โFAฤฐLโ; IFS([IลIKLAR-Farlar รงalฤฑลฤฑyor mu?],20)+ IFS([IลIKLAR-Yan ฤฑลฤฑklar รงalฤฑลฤฑyor mu?],20))
but if i select the first yes, it does not affect the result. The result is displaying default fail, after second chosing is yes, the total is changed as 40. I am not sure whether it works perfectly.
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.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |