-
Nested(?) If statements
Not sure if nested is the right term. I want the formula to show - If any of these columns (IT, SUS, HSE etc) have "Not Achieved" in them then look for the largest/ latest date from the columns IT comp. SUS Comp. HSE Comp. and display that date. Otherwise "Badges complete". The result column is a date column so not sure if…
-
Using IF OR MATCH to Check for Value in Multiple Sheets
Hi, I am trying to write a formula that will take a value from the sheet the formula is in and check for that value in other sheets. If the value is found in at least one other sheet, the formula should return "Y". If it is not found, it should return "N". This is my current attempt, but this just returns "N" for…
-
IF AND OR Formula *almost* works correctly but one part!
Hiya folks- all arguments work correctly except turning Health the color Yellow when Recommended Due Date is within 3 days of current date and status is not Complete. Here is what I need to accomplish: IF [Status] is"Complete" or "Cancelled/NA" then [Health] ="Blue" IF [Recommended DueDate] <= TODAY and [status] <>…
-
Multiple Sequences Need to Be Complete/NA to Provide a Complete Value
Writing formulas is not a strong suite of mine - I've tried a few routes (IF OR AND) but I'm either running into invalid formulas or formulas that are not netting the right results. I am trying to write a formula where I'm looking for sequence values to be either Complete or N/A and based on those sequences being one of…
-
I believe I need help with an IF OR formula
I am trying to create a formula where my swimlane shows as complete if the completion is complete, but if a project is in progress but the status is still green, I want it to show as On Target. How do I make my formula so that green is On Target unless it is marked as complete, in that case it would be called complete.…
-
Overall Project Health Formula
Hiya folks, We want one field to show Overall Project Health. Ideally, we would figure out how to average the colors and/or tasks past due to return RYBG for the overall projects (about ~230) so that we can report it on a Dashboard. Any ideas on formula would be so appreciated. Circular reference error formula in OPH row:…
-
Ignoring Blanks when Identifying Duplicates
Hello! I've been struggling with this and keep coming up with nothing. Would love some help please! We have a sheet with sessions for a conference, in which I've added helper columns to identify the duplicates (for speakers that have more than one session at a time). As of right now, everything is coming up as a duplicate…
-
Nesting IF/OR Statement(s)
I'd like to combine multiple IF/OR statements so when I update my status column another column will auto update: When Status is Complete or Received list Full, if not, list Empty; when Status is In Process or Quoted list Quarter, if not, list Empty; when Status is Dispatched or Ordered list Half, if not, list Empty. Is…
-
I need help with formulas
I am working on formulas to get approvals in one of my sheets - But there are more than 2 options and I'm finding it a bit confusing… IF both directors APPROVE = Trade Off Accepted IF one director APPROVES and the other one is PENDING = Pending Acceptance (Would I need two of these?) IF both directors REJECT = Trade Off…
-
Automated risk rating
Hi All, I am building a risks log and I am getting stuck building 'if and' statements to automate the rating. I have a drop-down column for Likelihood and a drop-down column for Impact, and based on these two fields, it would be great if the rating column showed Low, Medium, High, or Very High according to the matrix…
