-
How to Copy Rows and then update Rows from mastersheet to new sheet
I have created a new sheet (sheet 2) which is linked to another sheet (sheet 1). I have copied over all the information from sheet 1- sheet 1 rows will be updated and changed as the year goes on but in addition to this new rows will be added. I have set an automation to copy rows when added or changed but I realise I just…
-
How to hide a formula in one sheet ?
Hi everyone , Is there a way to hide a formula in one sheet . I want to share the sheet to some partners but I don't want them to be able to see the formulas . I've locked the coulumns containing the formulas but it's not enough . Is there a solution ? Thanks in advance .
-
Formula Help- Calculating Costs
Hello, So i have this formula: =COUNTIFS({Environmental Incident Tracking Range 3}, "1", {Environmental Incident Tracking Range 7}, =(2020), {Environmental Incident Tracking Range 5}, "R507", {Environmental Incident Tracking Range 1}, "Leak / Fuite") But i need it to match this criteria, but calculate the cost accumulated…
-
Time formula: how to add 4 hours to my appoint time column?
Hi, I have a appointment time column and I would like to use a formula and add 4 hours to get the End time. Is there an alternative way to do it like sort of formulas? Kindly help, I need this to my report this week.
-
Weird behavior with MATCH
HI, I'm trying to build a scoring system but i've got some strange behavior from MATCH. What i finally did was putting all items in one new grid , the formula in another and this is what i've got? Formula under Strategic fit : =MATCH([Strategic fit]@row, {New Sheet Range 1}) Formula under priorities : =LEN([Strategic…
-
Changing Reference File
Hello, I have created these files: A raw data sheet - I will copy data extracted from various systems and paste them into this raw data sheet A sheet for metrics - a summary sheet for summarizing statistics from the raw data sheet Multiple reports for different purposes that draw data from the raw data sheet Multiple…
-
A single sheet that can pull data requested from sheet with Form responses
Hi, The end goal is a single sheet where someone can input something to pull from another sheet that was populated by form responses. Example using ice cream: Personnel completes form that provides how much they like different types of ice cream. And they use Harvey balls to select how much they like the ice cream. I want…
-
Formula to populate a 1 or a 0 based off of criteria
I have 6 columns where each of them will contain Yes or No. I want to know when a row contains all Yes's, and also when a row contains ANY No's. I added an additional column for "Approved" (for when all of the 6 columns is Yes), and "Denied" (for when any of the six columns is No). My end goal is to be able to sum those…
-
FORMULA - COUNTIF WITH 2 ARGUMENTS
Hi, In sheet summary I am trying to count total number of 'EVENT CATEGORY' that is 'STATUS' The formula I have tried is =COUNTIF([Event category]:[Event category], "Webinar" [status]:[status], "complete") Both columns are dropdown single select if that makes any difference. I am able to count by event category but adding…
-
Using LARGE with duplicate results?
Looking to find, for example, the 10 largest projects in our system by allocated resource hours. But what happens when there are duplicates/projects with the same number of allocated resource hours? =LARGE(({total hours}), n) From the result of that formula, in another cell, I then collect that respective project's name…