Valid if any of the 2 options are selcted

[vicks88ster]

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 

[Suvrutt_Gurjar]

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

[vicks88ster]

Yes.. Enum options are present

[Suvrutt_Gurjar · Accepted solution]

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

[vicks88ster]

That worked in one go.. Thanks!!!!