Google Sheets Jobs

Hi I need a google sheets Apps script Guru who can hep with the following: I will create a google sheet and save it in my google dive in some folder. this folder will have 3 CSV files. Upon launching or using some button I want to import the CSV data into 3 tabs Once imported I want a line graph creating Sheet 1 & Sheet 3 (if it exists) >> Sheet 1 and Sheet 3 layout is the same except the values.. if sheet 3 exists then overlay the graph already created from sheet 1 I reckon this is 2 hours worth of work for someone who knows what they are doing. I have an example here 3 sheets are imported manually.. graphs are also added manually. I want to create these at the touch of a button if possible

We want to build an interactive calculation/dashboard where we can input order information (for example) headcount of people ordering, protein selections and it will calculate according to our formulas a combined number of proteins, starches:( rice, breads, etc...), drinks etc.. according to the portions we have set. Ideal there should be three sheets: - Housespread calculation sheet - Lunchboxes calculation sheet ( need to come up with random distribution formula) - Combined dashboard (a better version of the gameplan that is built by hand) reports it will yield: - Kitchen prep list - Combined assembly table - Individual order driver-checklist This is specifically for the restaurant industry so prior industry knowledge will be helpful. The links below are for the calculator we cur...

I have a system with customer files and a master file. I need just one function in the master file that will write/update/delete new entries when any edit is done in the customer files. Here is the technical task; Create a Google script onEdit function that will 1. add any new entries in the columns (A2:D) of the customer spreadsheets ('Customer1', 'Sheet1'; 'Customer2', Sheet1...), to the 'Master spreadsheet', 'Sheet1' , (B2:E) 2. check and update any existing entries based on the columns A and B, and if the entry already exists in both and A and B, just update the values in the columns C, D, E, if not update the whole row. 3. if the entry in the customer spreadsheets ('Customer1', 'Customer2', ...), columns B, C or...

Not looking for beginners. We are looking to hire a excel & gsheet expert for a part time job. We are looking to share some excel data with our audience but doesn't want them to edit the sheet. We are also looking for invoice creators in excel & gsheet. We are looking for excel pro who can create almost every possible thing in excel & gsheet. Payment will be on a monthly basis. Please share your previous work.

I want send updates clients on there Fastivs and annevarsary and birthdays from my WhatsApp my api Defrant defrant number Some work done but some panding

I need the attached PDF turned into a Google Sheet

I’m trying to understand how to view my data in the best way possible - i have some metrics I want to track on a long list spreadsheet of sales contacts - I’d like to be able to scroll through the list but only on half of the screen so I can view metrics aswell

just need some help figuring out how to make a formula do what i need it to, the formula that i need takes one page in the sheet and moves over all of the values within a specific range on that sheet to a list on another sheet, the problem i am having is that the formula looks like this =textjoin(char(10),true,LOADS!A2:A14) but when i pull it down to copy the value it turns into this =textjoin(char(10),true,LOADS!A3:A15) what i need is to know how to make the next formula start at where the last formula ended

Create exportable databases in google sheets to work with our own ERP

From start to finish my clients know what they want but they need to see value in the process and work put in before we even start working together. That is where we start building out a brief. A brief is an explanation of all the things we need to share with the client in order that they begin the sales process with us. I need something similar created for all my clients right after what we call a "Discovery meeting" This brief will allow for us to pitch really high paying clients full blown marketing strategies for their companies. The person that will be able to do this task will have to look at the client, their competitors, market trends, a pricing sheet and create an outline of what it is exactly that we will be pitching to the client. Examples are below. All the resource...

Looking someone to create a cool design for SEO audit report template for us to share with our client.

To create the best detailed list of top 7,000 influencers in Egypt. The list to include the following (all of the following, each must be in a different column) • Profile Link for Instagram • Name • # of Followers • # of Following • Male/Female • Email • Phone number (available phone number on the bio AND on the contact button on the mobile app) • Person or Page: identifying if the profile is for an influencer/person or a page • Other channels: getting ALL the other channels (tiktok, Youtube, Snap, Twitter, website, ( you may need to research online for this) • Family Status: o Single (if the influencer does not show a partner) o Couple (if the influencer shows their partner but no kids) o Family light (if the influencer shows their fa...

Buscamos un desarrollador con experiencia para realizar un trabajo puntual de creación de una calculadora dinámica en nuestra página web. - Necesiario experiencia con wordpress-elementor. - Se valora el uso de plugins (tanto de formulario para los inputs como de visualización para gráficos). - Los parámetros de entrada (inputs para los cálculos) así como los elementos de visualización (colores, formato y layout) ya están ya definidos (imagen adjunta). El proyecto consta en convertir en dinámica una simulación estática ya creada. Ejecutar el registro de los inputs en una base de datos y su lectura para la visualización en los charts. Se valora también la capacidad de aplicar otros el...