Find Jobs
Hire Freelancers

Google sheet query

€8-30 EUR

Avslutat
Publicerad nästan tre år sedan

€8-30 EUR

Betalning vid leverans
I use google sheet tables in which I fill in multiple "databases". I use data from databases to structure them with a google sheet and use them for reports. The existing formula I use to get my data out is: = if ($ B $ 1 = "Payment"; query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '" & $ A $ 1 & "'and B =' Output invoice 'order by'" & $ F $ 1 & "'"; 0); query (D! $ A $ 2: $ T; "select I, A, D, K, L where C = '"& $ A $ 1 &"' and (B = 'Construction site - situation / invoice' or B = 'Invoice' or B = 'Offer / proforma invoice') order by '"& $ F $ 1 &"' "; 0)). it needs to be refined to automatically summarize projects by summing up an individual project and providing data according to a formula. An example is in the task file. Eg. it is necessary to summarize the "Daruvarske toplice" project and the "Lipik specijalna bolnica" project. Picture "tablica e" is current state, and picture "tablica e new" is future state. Formula must be in quary form as current.
Project ID: 30538184

Om projektet

17 anbud
Distansprojekt
Senaste aktivitet tre år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
17 frilansar lägger i genomsnitt anbud på €28 EUR för detta uppdrag
Använd avatar
Hi there, You want to have the Query formula modified? You need a new group "New Project" and the sum of each groups added in the Query formula? Please message me if this is any of what you need. I'll be standing by to help. -Ige
€40 EUR Om 1 dag
5,0 (39 omdömen)
5,3
5,3
Använd avatar
Hi, Greetings! ✅checked your project details. I can build google sheet query. I Have 4 years of experience with Data entry, Data analysis, and MIS Management. I have Power BI and Excel/google sheet skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process and the quality of my work is high. Please Ping me the chat box for further discussion Thank You
€30 EUR Om 2 dagar
5,0 (30 omdömen)
4,5
4,5
Använd avatar
Hi, I am ready to start right now. I can help you with your project according to your requirements. I am interested in your project. I ensure I will complete the task successfully and within the specified time. I love the perfection of work. You can see an example of one of those project in my portfolio here: https://www.freelancer.com/u/Monirulop If you are interested to work with me message me, waiting for your message. Thanks! and be safe, Monirul
€30 EUR Om 1 dag
4,9 (23 omdömen)
4,0
4,0
Använd avatar
Hello, I can help you with this project. From what I understand you want the query to show summaries of multiple projects. I'm pretty sure I can do this job for you. I have created many google sheet files and excel files both using formulas and scripts, so I'm the correct person for this job. Let's talk more in detail, and if possible can you share the google sheet files, so I can analyze it further to ensure it is according to your needs. Thanks and Kind Regards.
€30 EUR Om 3 dagar
5,0 (6 omdömen)
3,1
3,1
Använd avatar
I've been craving this for a long time, this job suits me perfectly, because I'm the best at writing and editing data professionally
€19 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello I have 4 years of experience in this field IL do my work neat and clean and also my speed is very good so do select me for this work
€19 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi, I have read your job description and will work as per your requirement within time.
€19 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I can complete your project as you need i.e. today because I have an experience of 3 years in this field and my main business is data entry.
€19 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I'm a Data Analyst, Who can work on Excel with full knowledge and i'm a certified Microsoft Excel Expert which can help you in cutting down the project timing and i can help you with implementing easier technique to simplify it.
€22 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hi there, I am expert in Web search, Research, Market Research, Lead Generation, Web Scraping and Data Entry. Lets have a quick chat on this project to clear further details.
€25 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I will deliver your project in time and there will not be delay in my work. I assure that you will like my work. I am here for long term work relationship so will give 101% best output from my end so that you consider me for future projects also.
€19 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello, I have fully understood your requirement and went into details of your input and required output file. I have several years of experience in working with excel and am a established programmer. I am new to freelancer and will really want to start my journey by providing you high quality and error free user friendly work, Thanks and hope to work with you on the project.
€10 EUR Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I am expert in this work because I am doing this since 2016. so, please give a chance to doing this.
€19 EUR Om 7 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello dear client, Thanks for posting the job. I went through your job carefully and wish to inform you that I'm very much glad to accept this job which matches with my potential. Please find below my skills and standard of the expected service.... ●Undergraduate UGC of Sri Lanka ●Years of IT related experience ●High quality servise guaranteed ●Charging very reasonable rates for you jobs ●Extra fast delivers ●Consistent work long hours for urgent jobs ●24×7 availability ●Client will be updated throughout the job done ●Make your right choose and get your job done with the expertise professional..... Cheers ♡♡♡♡ Menik WhatsApp +94715685575
€12 EUR Om 1 dag
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för CROATIA
Croatia
0,0
0
Medlem sedan okt. 29, 2015

Kundverifikation

Andra uppdrag från denna kund

Google sheet automatic e-mail
€8-30 EUR
Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.