google sheets

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...

Hello, I am hoping I could get some assistance with a formula in google sheets. I want to use an index/match formula, to return a value should it match two values in my current sheet. I currently am using this formula...

Creating a title for this was tricky. So I have a spreadsheet in Google Sheets where I have three sets of data that I need to add together but there are times one or two of the cells might be blank. Basically, I am trying to create a Score for a call center rep where a call is worth 8 points...

I want to use a google sheets formula in power bi, but I am unable to use it, since there is no image function in power bi. This is the function I need to use: =if(LEN(celda)<1;"";image("https://chart.googleapis.com/chart?chs=250x250&cht=qr&chl="&celda)) Can someone please help me find a way to...

I have generated an excel sheet in google sheets, that gets the history of currency rate changes from some coins to USD. What I want to do is compare the date of the column in google sheets with a dummy table with dates and if they match, then multiply the value from the rates column to the data...