-
Formula Help
Hi, I have a due date column and a status column. The different options for status's in the status column are - In Progress At-Risk Completed Postponed What I would like is a formula that can do the following - IF due date is empty or prior to date listed - mark status column to In Progress IF due date is within 2 days -…
-
Changing a cell's values from code in a different cell
Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF(column@row=X, different_cell=XX, different_cell=XXX)
-
Formula for non-duplicate values
Hi, Is there any formula to populate only 1 value of each value listed [Column1]? I.e., column 1 has something like the below, 45 56 45 55 55 56 46 56 Is there any formula to only show the below? 45 46 55 56 Thank you!
-
Can't add days to a Date
Hi, It seems like I cannot add days to a date by a formula. Formula is below: =[CX Finish Date (F)]@row + 2 And see the Screen shot below, above formula adds the number "2" to the end of the date as a text. However, it is expected to have 2 days added up to the date that was selected. Thank you in advance.
-
#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…