-
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…
-
Need help applying AvgIf and/or AvgCollect
I am trying to find the average of a column with specific criteria. I have avg TAT and I am trying to find the average when the Run Type is specific.
-
Creating a formula to track number of days but with a catch
So I have been tasked with creating a formula that tracks the number of days an element is "No". However, there are multiple forms submitted each day so I do not want to count the number of times a "No" is selected. It needs to be a formula that counts the consecutive days but then resets to 0 if the element has a "Yes"…
-
Pre-Populate Form with Entire Field from Sheet
Hello Community, I am trying to figure out how to pre-populate a form with a multi-word field. I know how to populate the form with a field and can provide part of my formula below, but it only brings in the first word of the field and not the entire thing. Can someone please let me know how to bring in the entire field?…
-
Formula for multiple columns - Incorrect Argument Set Error
I have spent more time than I'd like on this formula. I keep getting a #Incorrect argument set error. I would like to provide different direction based on when specific columns have a yes answer. It was working fine until I added the final column Used to Provide Information - Handout. Now I can't get the formula to work…
