How to build this?

AppSheet AppSheet Q&A
1

IF(([Report Reason]=“Chem Treatment”),[Well Status]=“PASS, [WELL Status]=”")

I have a dropdown in ReportReason and when people select “Chem Treatment”, I want the column “Well Status” to be PASS. Column Well Status is EMUM with PASS or FAIL.

2

Hi,
How about this:
IF(([Report Reason]=“Chem Treatment”),[Well Status]=“PASS”, [WELL Status]=“”)

You will also need to make sure that your Well Status can accept “”.

This might help in the future:

3

EIG:

IF([Report Reason]=“Chem Treatment”,[Well Status]=“PASS”, [WELL Status]=“”)

Thankls EIG
What should be the type of the column, I had enum and did not work. I did Text and it gives me Yes/No.
How can i get it to say PASS?

4

Try IFS([Report Reason]=“Chem Treatment”,“PASS") with the initial value.

5

Thanks
I tried using the IFS statement. It does not change dynamically. Selection for “Chem Treatment” is ENUM with 2 options to chose from. “Test” “Chem Treatment”. ONce “Chem Treatment” is chosen, I want to Report Reason to say “PASS”. If input is “Test”, it should say “Fail” and grey out.
Please let me know how to model “Report Reason” and “Well Status”
What Type should be “Report Reason”?
What Type should be “Well Status”?
What expression should I use for “Well Status” and “Report Reason”?

Thanks in advance

Regards,
Amol

6

For the Report reason field you need to create an app formula IF([Chem Treatment]=“Test”,“Fail”,“PASS”).

1 Like