Please Help for "Valid_If"

Remi_BILLARS · 06-01-2020 10:28 AM

Hello,

I can’t use a formula that may seem simple to you …

First, in valid_if I put (ALPHA [ALPHA] and everything is ok, I see my list of people.

BUT I want to add a condition: I want the list to appear only for people [ALPHA] when the column [Grade] = “Mdc”.

I tried:

BUT Nothing works

I am not an app sheet expert but I need your help. Sorry for my english and thank you very much.

Bahbus

IFS("Mdc"=[Grade], ALPHA[ALPHA])

Remi_BILLARS

I just tried but in the ALPHA form disappeared.

So I tried (“Mdc” = ALPHA [Grade], ALPHA [ALPHA]) BUT error:

“Cannot compare Text with List in (“Mdc” = ALPHA [Grade])”

Do you have another idea?

Thanks you.

Vinit_Mishra

(Mdc” = [Grade], ALPHA [ALPHA])
Please try this

Remi_BILLARS

The result filters but does not really give me the wanted list.

Details of my data source:

My form opens on this sheet:

and my ALPHA and Grade list that I want to filter is on this another sheet:

(I created an enumList with Ref)

SO the expresion is ALPHA[ALPHA] is Ok but I can’t add the [Grade] condition.

I’m sure it’s not that complicated …but enough for me

hru

This?

FILTER("ALPHA", [Grade]="Mdc")

Remi_BILLARS

« Cannot compare List with Text in ([Grade]) = « Mdc »)…

hru

Its related to the column types:

FILTER("ALPHA", IN([Grade], {"Mdc"}))

Vinit_Mishra

Hi,

IFS(“xxx@yyy.com”=USEREMAIL(),Users[Full Name])

here I am listing all the available users if email is matches(User is table name).

Hope it will help you.

Thanks,
Vinit