googlesheet

I have sport data that I imported from an api There is a particular column named G in which, two data are combined and partitioned with a colon ( : ) (attached is the pic) So when the column is imported into the sheet, it changes format to hh:mm:ss (time format) e.g 56:45:00. Kindly...

hello all, I would like to create a bar graph with percentage for how percent of classroom to dept. also, i like my dept to be my x axis. Class IDs Place Duration Dept 12345678 firstfloor 30.98333333 Math 12345679 secondfloor 45.15 Math 12345680 secondfloor 33.3 Math...

Hi, would greatly appreciate if anyone is able to help! I am working on editing a macro that involves vlookup copy/paste data from Worksheet A (IB) to Worksheet B (Inbound POs). However, it copies empty cell in Worksheet A and overwrites the filled cell in Worksheet B which i do not want...

I have a problem with my sumifs I want to sum a specific dropdownlist and sum the whole month this is my code. C - Amount B - Dropdownlist (Expensive and Income) A - Date E - Months =SUMIFS(C2:C7,B2:B7,F1,A2:A7,">="&E2,A2:A7,"<="&EOMONTH(E2,0)) please help me with this if there is another...

We have a bunch of raw data dumps with sales info and I am trying to build a breakdown so we can determine how much of each products monthly sales were organic versus email promotion versus rebates, etc. So you can see the image above. The if statement goes like this: If BreakDown="units"...

Hi Guys, this is my first post and I have always found this forum helpful for my excel queries, I need to know if there is any possibility to connect my excel pivot with Googlesheet?

1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault? 2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet...

Hi All - I am trying to use "Match" inside a "Vlookup" for the Index input on the "Vlookup" formula. I am trying to pull "Estimated Hours" from one spreadsheet to another spreadsheet using "Work Order ID" as the ID> Work Order Log to Work Order Log - Rollup Spreadsheets...