google sheets

How do I create a 12-month table with several variables in Excel? Say I start with 5 possible X values and have two growth factors, each with 5 proposed values I want to test (Z1-5+Y1-5) through the end of the 12th month and see the product of each combination (125) like a large tree diagram would.

Hi everyone, I'm new to this forum. I use Excel on a daily basis for work and have recently started playing around with Power Query for pulling in data from the internet. Haven't been able to find any info on this specific problem that I've been having. Google Sheets has a handy finance...

I want to add 7 hours to timestamp if time is 01:00:00AM and add 1 hour if it's not 01:00:00AM. I tried - if(A2=TIMEVALUE("01:00:00AM"),A2+TIME(7,0,0),A2+TIME(1,0,0)) A2 = <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>08/Jan/19 8:0:0AM 1...

I'm trying to convert a model that has a complex sumproduct formula: "=SUMPRODUCT($AX14:CB14,N(OFFSET($BX$4:DB$4,0,COLUMN(DB$4)-COLUMN($BX$4:DB$4))))" And once the column count gets to 31 (range of AX->CB...BX->DB), I get the following error: "SUMPRODUCT has mismatched range sizes. Expected...

I'm wondering if having a more current version of Excel uploaded onto Google Drive will affect the functionality of what can be done? For example, if I have a file created in Excel 2016 and upload it to Google Drive, will I have more Excel features/functions than if the document was created in...

Hi, I manage housekeepers in a hotel and I am trying to create a spreadsheet that helps me make room cleaning assignments based on certain criteria. The sample sheet shows the 3 columns of criteria for each room. Room Type, Room Condition, Stay-C/O (Stay over vs. Check out). I also want to...

I need help with ONE FORMULA or ONE SMALL SIMPLE SCRIPT in Google Sheets to solve this spreadsheet problem. I have a master spreadsheet with all my formulas in a row. I want to have many slave spreadsheets pulling the formulas in via IMPORTRANGE. So if I need to change a formula I can change...

I have data from different campaigns in separate sheets [per market]. Actual data is five sheets but in the dummy data, I've only worked with two sheets. In a summary sheet, I want to be able to find the correct value for Sessions in column I of 'Email Sends' sheet. This should check for the...

Hi Guys, How do you create searchable drop down list as seen on google sheets? I have excel 2016. I want to use the drop down to complete a column in a table. I know I have to use data validation. Thank you.

could anyone correct my function. tired of copying and pasting this formula over and over. Trying to get it to work in a script. cell D3 is an example of what id like to input. Thanks https://docs.google.com/spreadsheets/d/13Dr8cFYFE9xNTGSYyFbAY4_vKjANavSa7GcSd-6hRhk/edit?usp=sharing

I am very familiar with conditional formatting, however this situation presents a different kind of obstacle for me. I need a script that will change the cell to the left,right and below etc, a different color if a condition is met without being attached to a cell number designation(A1 etc...)...

I have a bunch of data in a Google Sheet and I’m trying to create a simple script that’ll loop and copy it over into the correct place in a second Google Sheet. DM SAMPLE SHEET (SOURCE) SM SAMPLE SHEET (DESTINATION) Rules for copy and paste: Loop through each row in the source sheet. If...

I have a google tracker which I updated everyday by uploading data from Excel. The process is cumbersome as many times the sheets/excel freezes. If there a VBA code/excel add-in that I can use to upload my data to google tracker from excel. The code should delete the old data on sheet and...

Dear all, Kindly advise, why is it happening that the first two charts here have lost last few "X-asis" labels? In comparison with the other charts, where all the labels are present, and the same formulas and data ranges are used for X-axis...? Also, is there any way to switch the vertical...

Hello- Not sure this is the right spot for this one... I have issues with coworkers uploading an Excel file that I have password-protected into Google Sheets, which removes all of the protections I have created (sigh), and allows them to see hidden sheets, etc. I am wondering if there is some...

Hello all, Here is my challenge: I have a spreadsheet made up of 5 different sheets. Four of these sheets represent a different company (Company A, B, C, & D) and show their prices for a range of products at a range of quantities. I then have 1 sheet called “LOWEST PRICE” that pulls whatever...

Hello all! I'm hoping this will be a fairly easy fix, but I can't figure out how to get it to work. We assign tasks to our team, and everyone has their own tab. There is a "MASTER" tab that keeps track of the name of the task (A2), how much time was budgeted for the task (B2), and how long it...

HI, I am trying to do something that I thought should be quite simple. I am using Google sheets, not excel, on a Mac in Chrome. I have 10 columns and multiple rows of data, which is my master data. In the same workbook, but on a separate sheet, (so not importrange) I want to reflect that data on...

I hope its ok to post questions about google sheets... I have the following problem: I need the following formula to convert into FEET" & INCHES" only. For example, my formula right has 13.8750(13' 7/8") converting to 166.5 INCHES. This conversion is correct but now what I need it for. I need...

Hello, I was able to search and find to codes that independently was able to get to work/accomplish what I want it to do. However when I try to include them in the same sheet, it looks like code#2 cancels out the first one. Is there a way to combine the two so they both work? Code 1...