Create a formula in Google tables
HTTPS://docs.google.com/spreadsheets/d/1pB2qz1yoP_3lQm7cwQVJev4un7UsHmub/edit#gid=1387170361
The list of Georgia has Routes and objects that are part of the route.They need to be reorganized according to the rules on Georgia done
Each object has three lines: Object name, Object type and include?I translated a copypaste with a change of position text data on the Georgia done routes, but in the Location column you need to gather all the objects of one route in one cell to bring in the following form:
(N1) Name of Location exactly as in the DB that is included in the route [type]
Name of Location exactly as in the DB that is NOT included in the route [type]
(N2) Name of Location exactly as in the DB that is included in the route [type]
Where
(N_) - number for the objects that are included in the route
Name of Location exactly as in the DB - Object name from the source list
that is included / that is NOT included - means there is an object on the route, the field includes?in the original list
[type] - Object type from the previous list has 3 values: Winery / Horeca / Attraction.That is to set [W] / [H] / [A] , depending on the type
Then I will use the same formula for other countries (List in the table)
Client's review of cooperation with Oleg M.
Create a formula in Google tablesI thank you. It works quickly and quickly 🙂
I recommend the executive!
Freelancer's review of cooperation with Rustam Tagirov
Create a formula in Google tablesComprehensive TZ, quick check and payment. I recommend cooperation.
-
1115 109 0 Hello to Rust.
I am specialized in working with Google tables. Write to me to discuss the task.
Current freelance projects in the category Information Gathering
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 2 hours 20 minutes back ∙ 4 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 2 hours 32 minutes back ∙ 7 proposals |
Carrier databaseInterested in compiling a database of carriers in Ukraine for the year 2026, including tankers, tarpaulins, grain carriers, and others. It is preferable to develop a table. Information Gathering, Data Parsing ∙ 1 day 6 hours back ∙ 29 proposals |
Digitization and structuring of official questions from the Traffic RulesLooking for a performer for technical work: transferring the official publicly available database of questions from the Traffic Rules (TR) into a structured Google spreadsheet and organizing accompanying images. Data Source Only the official state source — the Main Service… Information Gathering, Data Processing ∙ 2 days 7 hours back ∙ 22 proposals |
We are looking for a person with knowledge of the German language for a company presentation.
115 USD
For our company, which is engaged in industrial assembly in European countries, we are looking for a person with German language skills (B2 / C1) — remotely, part-time What needs to be done: Call potential clients in Germany from a prepared database. The goal of the call is to… Information Gathering, Lead Generation & Sales ∙ 3 days 2 hours back |