Project translated automatically. Log in or register, to view the original Hello to you!You need to make the conditions in the Google table.1)There is a column of the Customer (the falling list), the Executive (the falling list) and the Value.Suppliers 5 and customers 5.You need to do the following: -if the customer No. 1 and the executive No. 1 are selected, then put in value 10.10.2023/1 -if the customer No. 1 and the executive No. 2 are selected, then put in value 10.10.2023/2 -if the customer No. 1 and the executive No. 3 are selected, then put in value 10.10.2023/3 and so on... -if the customer No. 2 and the executive No. 1 are selected, then put in value 10.10.2023/11 -if the customer No. 2 and the executive No. 2 are selected, then put in value 10.10.2023/22 and etc... that is.How to check: if the executive X and the customer X are selected, then submit the date 2)there is the Column of the Executor (the falling list) and the IBAN (the falling list with the full number of the IBAN account).There are 5 performers and each performer has 2 to 5 IBAN accounts.You need to do the following: If the executive number 1 is selected, then give the value to the IBAN column: Private, not the full IBAN number of account, but only the name of the bank-Private, the same executive has the IBAN monobank, I choose from the list of monobank and is submitted to the IBAN monobank. and so on.for all the performers.I only need formulas so that I can set and enter the data myself.

Proposals 1

Petro Shpak

Winning proposal

13 0

Projects 13
Rating -
Rating 419

Budget: 500 UAH Deadline: 1 day

Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 15 proposals 31 July

Not specified
Construction of an automatic scheme for the movement of goods and monetary flows

34 proposals 30 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 41 proposals 27 July

178 USD
Development of an analytical system with a dashboard

Enterprise Resource Planning (ERP) 43 proposals 20 July

Not specified

Andrey Oganyan
Odessa, Ukraine

Projects 7
Rating -
Rating 424

Andrey Oganyan

Petro Shpak

Petro Shpak

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Construction of an automatic scheme for the movement of goods and monetary flows

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Development of an analytical system with a dashboard