Develop a table in Google Sheets

Customer Support, Client Management & CRM — incorrectly specified categories?

16 USD

Project translated automatically. Log in or register, to view the original

There is already an existing table in Google. This is a referral system. But it is not working

Column A - Client's First and Last Name

Column B - Client's Phone Number

Column C - Referred Person's Full Name

Column D - Referred Person's Phone Number

New clients are imported into columns A and B from our recording system via a csv file

Data is manually entered into columns C and D, and when fields C and D are filled, the client should automatically be added to columns A and B

Task:

Make it so that when importing the database, clients are not duplicated in columns A and B if they have already been added via C and D. There should be an automatic duplicate check.

The second task is - when fields in columns C and D are filled, the client is added to columns A and B

Proposals 3

Artem Portnoy

41 0

Budget: 700 UAH Deadline: 1 day

Good evening, I have experience in creating Google Sheets and Excel! I will do everything qualitatively and on time!

Olha L.

9 0

Projects 9
Rating -
Rating 723

Budget: 700 UAH Deadline: 2 days

Hello!
I have reviewed your technical task and am ready to implement the functionality for Google Sheets.

I am ready to start the project immediately after finalizing the details.

Vladimir Burgalov
Austria

Projects -
Rating -
Rating 135

Develop a table in Google Sheets

Artem Portnoy

Olha L.

Proposals concealed

Proposals are currently absent