I have two tables: “table 1” and “table trouble log”.
Table 1 shows all the machines I have in my stock
In the Trouble log table, I’ll tell you whether it’s in trouble or not.
What I want ?
I want the problem column (in table 1) to be filled with value yes if status from table trouble is set to active and when its set to disabled, the value does change to no.
veja o template do que eu quero
The simple approach would be to add a virtual column to Table 1 that looks up the machine’s status in the trouble log and displays the desired message accordingly.
I got what I wanted, create this chart.
I created the virtual column and used the formula:
lookup ([_ thisrow]. [machine], view, machine, availability)
It looks like this:
but how do I make it available [blank] and “Disponivel” in one only as “Disponivel”?
it’s possible ?
Just make them the same colour ?
Or make all blanks available. What you are saying is regardless of whether it is blank or available it must be available?
Need to see the columns in question.
the solution I found:
I put an IF() in the formula
Thank you so much for helping my friend.
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |