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 |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |