Appsheet Overwrite setvalue from OPEN to CLOSED

[desmond_lee]

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

[Marc_Dillon]

https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values

[desmond_lee]

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)

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2355953-if

https://help.appsheet.com/en/articles/2355961-ifs