-
#INVALID VALUE error with collect/index/match/small function
Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values from a source sheet. The frequency of the part within the source sheet is then…
-
NETWORKDAYS formula with future dates
Hi, I am trying to work up a NETWORKDAYS formula to calculate "Days Active", either calculating between the Approved Launch Date and Close Date, or Approved Launch Date and TODAY(), if the Close Date cell is blank(basically, stop counting the days once the close date is entered). I managed to use the following:…
-
Getting #UNPARSEABLE error
Hi all, I've four colums A, B, C, D. Objective is to A*B + C*D = total number. I'm getting an error. Not sure why? Highly appreciate if anyone can help. Attached is the error! Thanks.
-
Formula to separate address into 2 columns not working
I am attempting to use 2 formulas to separate an address that is comma deliminated, but the formula continually misses the mark. The formulas in use: Street address: =IFERROR(LEFT(Address@row, FIND(",", Address@row) - 1), "") City, State, Zip: =IFERROR(RIGHT(Address@row, FIND(",", Address@row) - 1), "") The Street address…
-
Auto numbering column
I am trying to do the same autogenerating reference numbers using a column that it is like the project class (What is it?) and the reference date will be the created column date that automatically assigned by system when the item is added. What i want in column Auto Ref Test that Generate the first Letter of "What is it?"…
-
Flag Parent Row if Child Task Meets Condition
I am looking for a way to count the children of a parent row, but only if the children have a particular attribute that is true. I'll then use that count to set up an CountIF to flag the parent row when the count is greater than one. The way my sheet is set up, I have parent rows and child rows. Milestone tasks are denoted…
-
I need help with the right "IF" or SUM IF formula
I want the formula to do a few things. 1 - Check to see if the row has CHILDREN and if it is a "Rollover PO" I have a helper column that is "CHECKED" if it is a parent I also have a column for "Rollover PO" 2 - If both are checked THEN I want the formula to SUM the CHILDREN in column [Total PO Spend] 3 - If the column…
-
Pivot Table Dates
I've created a pivot sheet using the Pivot App that includes a date of when a call was taken, however I'm having no success creating an actual date column from the column created by the Pivot App. Please see below for formula reference. Temp4 proves that Call Date, which is the primary column is not a date, which is…
-
Formula for Filter: Not in the last (x) days
Hi, What formula gives me the same value as the above filter? Would need something like COUNT IF {Range 1} Is Not in the last (x) days Thank you!
-
Max Collect Formula
I am trying to use max collect to display the latest step in a project plan based on the highest value in the "project phase" column that has been marked as green in the "Status" column. I am returning a vlaue of 0 no matter what I try to change here. any thoughts? thanks!