Valid if any of the 2 options are selcted

AppSheet AppSheet Q&A
1

Hi Guys,

I have this issue:

I have 3 options to select i.e.

Machine
Service
Lubricant

If chosen Machine : Dropdowns options Machine1,Machine2 shud appear (I was able to do it form SHOW IF)

But if service or lubricant either of them is selected - Dropdowns Service1,Service2,Lubricant1,Lubricant2 shud appear. For both the options Service or Lubricant.. Same dropdown shud appear

Basically,i am looking for a formulae in showif which can be shown when either of the condition is met

2

Do you have 2 enum columns to achieve this? Something like below?

First enum with options Machine , Service, Lubricant

The second enum with options

And second enum with Machine1, Machine2 , Service1, Service2, Lubricant1, Lubricant2

1 Like
3

Yes.. Enum options are present

4

You could try use valid_if on second enum such as

IFS(

[Enum 1]=“Machine” , LIST(“Machine1” , "Machine2),

OR( [Enum 1]=“Service”, [Enum 1] =“Lubricant”), LIST(“Service1” , “Service2” , “Lubricant1” , “Lubricant2”)

)

Please take a look at the article “Drop-down from Valid_If”

https://support.google.com/appsheet/answer/10107665?hl=en

1 Like
5

That worked in one go.. Thanks!!!

2 Likes