google spreadsheet

TASK TASK ID ASSIGNED TO TASK 1 200623175025 ADAM TASK 2 200623175159 JONAS TASK 3 200623184657 JAMES TASK 4 200623184918 ROSSI TASK 5 210623180111 WILLIAN TASK 6 210623191226 JONAS TASK 7 230623151100 JONAS SHEET 1 - TASK GENERATED BY Google FORM, Which we can report as...

Hi guys, I have the following challenge: I have 2 cells: The first one is being periodically updated automatically by some 3rd party script. It may be full or empty. The second one is being updated manually whenever the first cell is populated with some value. Is there a way to make sure...

I have a Google spreadsheet that has a list of problems, the resolution to those problems, and the status of completion. Column G is where the users are to enter the needed resolution to the problem. Column H is where the users indicate the status (with only three options): * Not started * In...

*This is not an Excel problem, this is Google spreadsheet problem. I am posting my problem here because I have received very helpful solutions on excel through this site, but now I am in a problem with google sheet and I don't have any platform except this, So please help me! I have a Google...

I'd like to calculate the number of days (column c) that each staff member has 1) committed 2) committed + proposed 3) committed + proposed + possible I need a formula to the effect of: SumIF column a = X AND column b = Y OR Z <tbody> Column A Column B Column C Bob Committed 3 Sarah...

Hi Guys, I would like to find duplicate emails from sheet2 ColumnA in Sheet1 ColumnH In Sheet1 sometimes in a cell there are multiple emails followed by ";" Need a excel formula to find duplicate entries in Sheet1 were I need duplicate entry results in sheet2 columnB in "TRUE" or "FALSE"...

Hi Friends, I have list of domains in columnH in Sheet1 and list of domains in ColumnA in Sheet2(SheetName:duplicatedomains) Need excel formula to run in Google Spreadsheet to find duplicate domains present in sheet1 ColumnH and results should show TRUE or FALSE in sheet2 columnB Attached is...

Hi Guys, I came across a some excel challenge were I need to remove Invalid emails from sheet1 of sheet2. I have attached the sample excel sheet. My Job is to maintain valid vendors list. So, daily I receive hundreds of new valid emails and need to remove invalid emails(I will manually collect...

I have made a few templates in google docs and used them for numerous excel documents. However, I need to change the format of the template (including titles & company logo/header). Is there an easy way to change this once and it automatically apply to all previous spreadsheets created using...

hi, I got Google sheet that update few times per day, i try to export the data to excel using the url of the sheet(after publish)and then Data--Get External Data--from web, but it doesn't work. Any idea how to solve it?

Within a google spreadsheet... Beginning in column I and continuing to currently column BW, there are formatted dates. (Specifically in row 5) I need 2 things: 1.) The column to auto delete if the date associated with that column is more than 7 days prior to todays date. 2.) A column to be...

Using Google Spreadsheet I want to add a Upcoming Birthday Event Sheet to my website ( I heard that i am allowed to display (embedd) particular cells on any webpage) Here are the conditions i wish to solve. Suppose A1 to A1000 have a list of names & B1 to B1000 have dates (birth dates...

I'm combining the index and match formula in excel to extract data given a specific reference. The problem however, is that my formula only finds the first listed piece of data rather than all the data that matches the reference. For example, I want to find ALL the projects that "Joe" is...

I need to pull data from one sheet and put it into another automatically. My home sheet has the following data... Column A: % of project completed Column B: Status of project (either in progress, on hold, or completed) Column C: Task Description Column D: Date project was started Column E...

Hello, I am working in google spreadsheets and need a few things to happen: 1.) Autofill 3 months worth of dates in relation to today's date in specific cells 2.) Automatically hide a column if the date in a specific cell is 30 days prior to today's date and 30 days after today's date 3.) On...

Everyday, I will input the hours I spend on a specific task (range G:EE), the date I started working on the project (cell C4), and the date I finished it (cell D4). I want google spreadsheets to automatically calculate (within F4) the total number of hours I spent on the project between the...

I'm trying to "translate" a spreadsheet from Google Sheets to Excel. Basically the spreadsheet has two tabs: Tab "raw data" contains rows of inventory info. e.g. Item #, Qty on Hand, Qty on Order, Color, and other specs. Tab 1 is where you type in a list of item #'s, and the arrayformula grabs...

hi, everyone hope i can get here an answer :) i am surfing around the web all over to check for a solution, but i cant get anywhere, maybe someone here can help me i have an excel sheet which has a macro doing some stuff with the data in it, and i want when the sub is finishing the work to get...

Responses to a survey are being compiled in a Google spreadsheet (GS) and this will be going on for the next few weeks. In Excel I'm building a dashboard to analyze the responses. It'd be nice if there's an easy way to refresh or update Excel to pull in the data from the GS. I've tried Power...

Hi all, I want to calculate Working time, which only include time from 09:00(9am) to 18:00 (6pm) on weekdays Monday to Friday only. I m using this Formula I want a formula that can correctly calculate time spend in all the folowing scenarios. > If Start Time is on week day in working hours...