Format rule with error

I need to create a format rule like this:

[machine] = lookup ([_ thisrow]. [machine], view, machine, machine)

but I need to have a condition in the machine column.

I Tried to do:

[machine] = lookup (select (machine view, [unavailable] = “YES”), view, machine, machine)

but the error is displayed:

Can not compare Text with List in ([machine] = SELECT (VISAO [machine], ([unavailable] = “YES”)))

help me please

Try IN([machine], SELECT(view[machine], ([unavailable] = “YES”))).

1 Like

worked perfectly

1 Like