Hello Appsheet Expert
I have a question. Does Appsheet able to write the initial setvalue OPEN in the column STATUS below to 'CLOSED' when the condition change? I put a live formula here because I don't know whether or not Appsheet has such capability
Solved! Go to Solution.
Thanks for the answer but how to write this expresion in Appsheet formula, =QUERY(ARRAYFORMULA(IF(D:D<>"",(IF(B:B<>"","CLOSED","OPEN")),"")),"SELECT Col1 LABEL Col1 'STATUS'",1)
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |