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:
(ALPHA [ALPHA], (ALPHA [Grade] = โMdcโ, true))
(ALPHA [ALPHA], AND (ALPHA [Grade] = โMdcโ, true))
FILTER (ALPHA [ALPHA], (ALPHA [Grade] = โMdcโ, true))
BUT Nothing works
I am not an app sheet expert but I need your help. Sorry for my english and thank you very much.
IFS("Mdc"=[Grade], ALPHA[ALPHA])
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.
(Mdcโ = [Grade], ALPHA [ALPHA])
Please try this
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:
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
This?
FILTER("ALPHA", [Grade]="Mdc")
ยซ Cannot compare List with Text in ([Grade]) = ยซ Mdc ยป)โฆ
Its related to the column types:
FILTER("ALPHA", IN([Grade], {"Mdc"}))
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
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |