-
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:…
-
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] <>…
-
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…
-
Changing Status Dot Color Based On Deadline Column
Hi, I've tried looking up other questions to answer this and got as far as this formula [=IF(Deadline@row <= TODAY(+14), "Green", IF(Deadline@row <= TODAY(+7), "Yellow", IF(Deadline@row >= TODAY(0), "Red", "")))], but it's not providing the proper results. I have a Deadline column and a Status column (which is the RGY…
-
Red, Yellow, Green multiple columns
Hello, I'm trying to create a formula that will put out a color according to multiple colors in a column. For example: there are columns 1 thru 6 that are rated red, yellow or green. In column 7, if any are yellow, it will output a yellow and if any are red, will output a red dot; if all are green, will output a green dot.…
-
Help with changing an entry if a date falls within a date range
I want to automatically assign our year quarters to a date range so the formula would select Q1 IF date created is between A/B Q2 if date created is between C/D etc - I have no idea where to start can anyone help?