-
If/Or Question
I would like RYGB column to; default ='Green' if today>[Proposed Start Date] = 'Red' if today => ([Proposed Start Date]-7) = 'Yellow' if [Actual Start] is not blank = 'Green' I am able to default to 'Green'. I have formula for 'Red'. I'm stuck when I try to add to my formula. The below is returning 'unparseable'. I've…
-
My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?
Hi, I am using this formula in a supporting sheet to calculate readiness for a task, but I keep getting zeros no matter what... =COUNTIF({Cross-site IHA Yes}, 1 / COUNTIF({Cross-Site IHA Ask 1}, 1)) Essentially this is saying, count all the "checked" boxes in column 1 and divide them by the number of boxes "checked" in…
-
Adding another IF Condition to my Current Formula
I'm looking to add this condition IF(Status@row <> "Complete", 0, 1) to my overall conditional formula below. Essentially I'm just adding the rule that if the status is complete than the value should be 1. I'm having issues embedding it in my existing formula, any advice? =IF(ISBLANK(Start@row), 0, IF(Start@row <= TODAY(),…
-
Whats wrong with this formula?
I'm using this in a metric sheet to count the term in a sheet that has multiple entries per row from a drop down list. It currently produces the error message #INVALID OPERATION. =COUNTIF({PH Roadmap Intake sheet Range 1}, CONTAINS([Primary Column]@row)) I was attempting to copy the one @Paul Newcome provided on 9/8/21 but…
-
Combine if ISBLANK in an existing formula that pulls percent complete based on duration
I have the formula that pull the percentage complete based on the duration between 2 dates =IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, MIN(TODAY(), [End Date]@row)) / Duration@row, 0) What I'm trying to do is add the formula below to make a combined formula. Which should make the number zero if there is…
-
I need help with an IF(AND..IF(AND.. formula that I'm getting an #UNPARSEABLE error on.
I'm trying to replicate a risk rating matrix (image included) by taking the data in 2 cells (Risk Likelihood & Risk Impact) to auto-populate a third cell (Risk Rating). Below is the formula that I am using. =IF(AND([Risk Likelihood]@row = "Rare", [Risk Impact]@row = "Insignificant"), " Low", IF(AND([Risk Likelihood]@row =…
-
Need help with a formula.
So I am trying to make a formula that encompasses 3 completion statues. So I have 3 fields that will all get marked to 100% and I want a main completion column to up date when the others hit 100%. So when Column A hits 100% then column D will be at 33%, then when column b hits 100% column D will update to 66% and then when…
-
Reverse Concatenate?
If I have a cell with a string of data such as the following: CONV-MB20210905-01 Is it possible to write a formula in another column to extract the date? In this case it would be 09/05/2021 Thanks
-
Too many cells referenced - Need formula revision suggestion?
Hi, I hope some of you all had a great Engage. It was my first and very helpful. As soon as I got back, I started using DataTable to solve for a big problem I've been having with a voluminous sheet, but found that my formulas are still too referential ... according to the warning below. The TLDR is that I think my formulas…
-
How to change count to percentage in stack bar chart?
Hi SS Community, I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") If it is a formula issue, what do I need to add/change about…