-
How to create 2-way sharing across sheets?
Hi, I am trying to make certain cells accessible for 2 way sharing. Is there a function like cell-linking that is available 2-ways? There is some financial data but mostly personnel/task and resources. Thank you, Esperanza
-
Formula error on Duplicate date check
Have found this formula in previous discussions but is unparseable. I have gone through it a couple of times and think it is down to wrongly set parentheses, or? Slutdato=enddate, Startdato=start date. Looking to flag (double booking) if startdates or enddates overlap. =IF(ISBLANK(Startdato@row; “”);…
-
formula for daily count
I'm looking to count how many times "blank" occurs in the status column per date. Entries are made daily and some days have multiple entries. I would like to set up a way to get a count of number of entries per day.
-
formula question
Hi, Please can you assist with a formula for the attached image. So if the induction column has "Yes" and Presentation column has "Yes" then the complete column should state "Yes". I'd like this formula to be inserted in the complete column.
-
Datamesh - way to transfer only parent row to sheet?
Hi all, I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet. The Pivot Table is set up where each row I need copied into the existing spreadsheet has a Parent Row (a number) and a Child…
-
Help with Index/Match formula
I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to check the box.
-
Nested if for FLAG column
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the date is in the past and (3)if another referenced value [Shipping Status] does not have…
-
Trying to find value text
I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @cell, "Q2_2020" @cell, "Q3_2020" @cell, "Q4_2020" @cell, false)" What I'm looking for is to find the triggering…
-
Helper columns vs #UNPARSEABLE error
This works for me using helper columns where I do count(parent) and count(children) =IF(OR(children18 = 0, Parent18 > 0), 1, 0) If I substitute the count(children) its #UNPARSEABLE =IF(OR(count(children) = 0, Parent18 > 0), 1, 0)
-
Time-tracker formula
Hello, I have a time-tracker and have 2 problems: For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Materials]$11, 2, false) * Hours1 When I remove the first entry which was a test, it messes up the calculation on the ones…