Cannot compare list with text

[nthnn060500]

Hello, I'm new with this app sheet thing. So i wanted to make the "Information Security & Div Head" field appear if i select it on the "Persetujuan Pemberian Data" field. But then it gave me an error that tells me it cannot compare list with text. Any solution would be appreciated 😄

[AleksiAlkio · Accepted solution]

You can use IN() expression for this purpose. Something like..

IN([Persetujuan Pemberian Data],LIST("Information Security & Div Head"))

[JPAlpano]

This IN() is indeed the solution to this problem.

[nthnn060500]

Thank you sir for the solution! Appreciate it 😁

[AleksiAlkio]

Good to hear it solved your challenge!