Drop down selection question
i have 2 tables
Table 1 - Door list that contain all relevant information
Table 2 - Job entry that record the installation work of a door
How can i make sure 1 door only have 1 installation job?
When i create entry in Table 2, i have a dropdown list from table 1. How can i have dropdown that has the door with
job filtered out?
or i just record everything in table 1, then create a slice to have 2 information? However, this method will seems a bit hard if i wish to manage the Google Sheets itself.
Or any other way to do so?
Try DoorTable[Door] - JobTable[Door]
@Aleksi_Alkio Not really understand what is this
If you add it into the Valid_If, it will read doors from the DoorTable and then it subtract existing doors from your JobTable.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |