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
Solved! Go to Solution.
Try IN([machine], SELECT(view[machine], ([unavailable] = “YES”)))
.
Try IN([machine], SELECT(view[machine], ([unavailable] = “YES”)))
.
worked perfectly
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |