I have a table to control whether our machines are set up at different customers. I have 30 different columns. 1 for each machine. It is intended that the employee should be able to use a Yes / no when setting up the machine. When they are with another customer, it must not be possible to select this machine if it is used with another customer in the same column. I can not find the right formula for this. Have tried ISBLANK ([_ THIS]), but it only takes into account the row you are in and not the other rows. Can anyone help?
LinkedIn
Twitter
