Create expression

Hello everybody…

I try to create field recorded value by app formula depending on recorded values in another field type (Enum).
For more elaborate
Field 1 include 3 values:
V1, V2, V3
Field 2 include 2 values:
val1, val2

I want to execute
If choose v1or v2 in field 1 the value in field 2 will record val1, or
If choose v3 in field 1 the value in field 2 will record val2.

Thank you in advance

Solved Solved
0 3 233
1 ACCEPTED SOLUTION

Try something like…
IFS(
IN([Field 1],{V1,V3}),“val1”,
[Field 1]=“V2”,“val2”
)

View solution in original post

3 REPLIES 3

Try something like…
IFS(
IN([Field 1],{V1,V3}),“val1”,
[Field 1]=“V2”,“val2”
)

OK, I tried this expression. Thank you Aleksi.

You’re welcome

Top Labels in this Space