Closed

Google Form/Spreadsheet expert - repost

We have created 2 google forms. These forms populate to 2 spreadsheets, A & B. A= "CRA Responses" B="LCRA Responses"

Spreadsheet B's data is imported automatically into spreadsheet A, all in one tab so they can be compared in a row. Although the import occurs, I believe these rows must be indexed and matched so that the whole row is bookended to it's respective row, linked into one row using the data found in column titled "Report Title" (seen in both CRA Responses and LCRA Responses".

The row data includes email addresses, dates, and text.

In general, here are the problems:

1) 2 forms will submit 2 different sets of data, where one unique id in the data is the text (limitations of text matching is understood). We want these sets to line up on one row in a summary tab.

2) After submitting a form, google forms allows the user to see a url which allows users to return for edits in the future. I'd like to automatically collect this url each time a form is submitted.

2) Lastly, we want a script which sends an email reminder to an email address in the spreadsheet if certain conditions are not met. (ie: a cell is not populated)

We intend to pay $25USD for the project.

Please download a copy to your google drive to imbed formulas: [url removed, login to view]

Please submit screenshots of your local project to prove the project is complete. please replay with dear ben.

-Ben

Skills: Data Entry, Excel, Google App Engine

See more: using google spreadsheet, spreadsheet script google, spreadsheet script, script google spreadsheet, script for google forms, prove it excel, indexed data, excel formulas expert, excel expert up, excel expert com, excel data entry form download, cra i, be expert in excel, spreadsheet google, google script spreadsheet, google excel spreadsheet, problems of data entry, excel expert google, row spreadsheet, google-form, google spreadsheets, google spreadsheet data entry 2, Google forms, google form-2, google form report

About the Employer:
( 0 reviews ) Ponte Vedra Beach, United States

Project ID: #4530047

6 freelancers are bidding on average $64 for this job

binaryromel

##### Excel and Google Spreadsheet expert here! Please check PM. #####

$66 USD in 2 days
(46 Reviews)
5.2
dangersystem

Dear sir, I am a professional data entry worker & can complete this project with your requirements, See PM for more details ! Thanks !

$55 USD in 1 day
(47 Reviews)
4.9
Viqtor

Hi, can help

$111 USD in 1 day
(7 Reviews)
4.4
GeorgeKazi

See your inbox.

$68 USD in 2 days
(0 Reviews)
0.0
azharawan1994

A data entry, sometimes called a typist, is a member of staff employed to type data into a database using a keyboard, optical scanner, or data recorder. The keyboards used can often have specialist keys and multiple co More

$30 USD in 1 day
(0 Reviews)
0.0
hariprasadec

hi , i have good experience with excel related work ,for your requirements i can have a EXCEL-VB script and do it very easel y. Thanks Y Hariprasad

$55 USD in 2 days
(0 Reviews)
0.0
bhadresh22

It'll be pleasure to work with you. Allow me to do this task for you. Thanks

$777 USD in 7 days
(0 Reviews)
0.0