Relate/lookup value from multiple tables

Ask for Help
1

I have a jobs table with an order number column.

That order number will match an order number in one of 5 google sheets. Each sheet is different, as it contains responses from 5 different forms.

How can I relate the order number in the jobs table, with the order number in one of the other sheets, without knowing which sheet it’s in?

The only thing I need to know is if that order number is present in one of the sheets, so I can show that step as complete. I don’t need to bring any values across to the jobs table.

TIA

2

You would need to create 5 separate relations, and then use an if-then-else column that returns true if any one of the 5 is not empty.

1 Like