-
Can we set cell linking based on conditions
I looked into a few formulas to do this such as if statements however I need to use cell linking because the value can be managed on both sheets. So if it changed on sheet A I also need that to update on sheet B (I have both an inbound and outbound link in the cell so it will work bi-directionally). But with cell linking…
-
If this, then that formula question
Hello! this may be so simple, but I'm having a hard time with it. I want a few things to happen - if the Approx trips per year is blank: provide the sum of just the Registration price field & the Approximate travel field If the Approv trips per year is NOT blank: multiply the approx trips per year by the apprx travel cost,…
-
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…