logo
down
shadow

GOOGLE-SHEETS QUESTIONS

If cell is blank preform formula else use value
If cell is blank preform formula else use value
I wish this help you I'm trying to conditionally set the value of a cell if there isn't already a value in it. I want to use a separate column so as to not lose the formula if a value is put in. This is what I'm trying. It's just saying FALSE in the
TAG : google-sheets
Date : November 05 2020, 11:01 PM , By : Tancumpeng Bingitz
Removing a row in sheet 2 from imported data from sheet 1 in google spreadsheet
Removing a row in sheet 2 from imported data from sheet 1 in google spreadsheet
help you fix your problem Seeing as you state you are "not a coder", and the code you pasted will not help you if you are referencing data from another page, I would suggest using a filter function to achieve your goal. You would add the following fo
TAG : google-sheets
Date : November 05 2020, 11:01 PM , By : Good Love
How to use index match formula that automatically expands in Google Sheets
How to use index match formula that automatically expands in Google Sheets
Any of those help In Google Sheets I am using a filter function to pull in Names into column A and a Timestamp into column B. Every time a second occurrence of the name shows up into columns A B of the list I want column C next to the prior occurren
TAG : google-sheets
Date : November 04 2020, 11:01 PM , By : Sudhir kumar
Include link created with CONCATENATE from one cell into IMPORTHTML formula in another cell
Include link created with CONCATENATE from one cell into IMPORTHTML formula in another cell
To fix the issue you can do I am generating a link combining two values from two cells C2 and D2 using CONCATENATE formula in cell B2. Then I want to include generated link into another formula =IMPORTHTML("URL"; "table"; 3 ) in A2 cell. A simple poi
TAG : google-sheets
Date : November 04 2020, 11:01 PM , By : Loay Youssef
Spreadsheets get unique names but ignore blank cells
Spreadsheets get unique names but ignore blank cells
like below fixes the issue =unique(A2:A) should work=unique(filter(A2:A,A2:A"")) to also ignore blanks
TAG : google-sheets
Date : October 24 2020, 03:08 PM , By : senthil
Find total duration of many overlapping times
Find total duration of many overlapping times
around this issue I have a list of dates and times for employee time sheets. The times begin in column F, and end in column G. Sometimes there are overlapping times for projects. The employee does not get paid for overlapping projects, yet we need to
TAG : google-sheets
Date : October 17 2020, 01:08 AM , By : Tamer
shadow
Privacy Policy - Terms - Contact Us © soohba.com