Project translated automatically. Log in or register, to view the original Hello, distinguished freelancers!)I need your help with Google tables: We have two tables: 1.Our internal warehouse table (column E), column with the goods available to suppliers F Reference to example: https://docs.google.com/spreadsheets/d/1o5pzzEdTu-hKEuO7pR_9N2XLx9M5F8p7A8c79uvOAVM/edit#gid=0 This table is internal, for use inside the company!2.Table to which we give access to our customers (Dropers) Reference to example: https://docs.google.com/sreadsheets/d/1qv-2Yt6j11a0e50X1kv9avXjZutlPLvxQVNAZIXzdA/edit#gid=0 The automatic display of availability in table 2, the availability from table 1, should be implemented according to the conditions: If in table 1 in column E(Acceptance) - the value greater than 0 has to be transferred to table 2 - If in Table 1 in column E(Feature) the value of: "No" or less than 1 has to be checked in column F (According to other bases), if the text contains the word "SETT" refer to Table 2 - Clarify the presence of If in table 1 in column E (Feature), the value is less than 1 or "NO", and column F does not have the word "Eat" to be transferred to table 2 - No available In both tables, the artifacts match the product, you can tie it together, or you can offer other options!)Waiting for your offer, a good and productive day for everyone!)The budget is conditional, offer your amount for the job.