Two ValidIf statements for a single row

[ur_Jim_buddy]

Hi everyone!

Been a silent lurker here for a while now but now I needed to raise a question. Quite new to AppSheet.

I have a field [New Company] that I wish to have two (2) validations:

1. The field prior to it [Current Company] should not be equal to the concerned field.

I used [Current Company]<>[New Company] in Valid If under Data Validity

2. The [New Company] should have options limited to the values defined in my table "OPT Companies"

I used OPT Companies[COMPANY] in Suggested Values under Auto Compute

3. I don't wish the employees to key-in new entries from the [New Company] field.

This is where my problem starts. I know that in order to remove the "New" option, you have to use the Valid If and use Select(OPT Companies[Company],True) but I cannot seem to input two (2) conditions in the Valid If field (or am lacking knowledge about AppSheet).

I hope I have given the right amount of clarification for my concern and looking forward to resolving this with you.

Thanks!

[Suvrutt_Gurjar · Accepted solution]

Please try 

OPT Companies[COMPANY]  -LIST([Current Company] )

in the valid_if of the [New Company] column.

[ur_Jim_buddy]

Hi Suvrutt,

Good day!

This is pretty clever. Now I wouldn't need to bother putting a validation message for each fields. Thank you very much!

[Suvrutt_Gurjar]

You are welcome.