-
Nested IF/AND Formula
Hello I am trying to create a matrix using the IF/AND Formula. So far the first part of the formula works which is this: =IF(AND(Probability1 = "Low", Impact1 = "Low"), "Low", IF(Impact1 = "Medium", "Low", IF(Impact1 = "High", "Medium") Now I want to add the other combinations ((Probability1 = "Medium", Impact1 = "Low"),…
-
Formula help
I have a request for time off form, when a request is submitted the person is notified that if they do not receive a response within 5 business days they can consider this approved, however I would like to create a formula that is based off the auto created date so if Approved column (where supervisor notes if it is…
-
Referencing checked state of Flag symbol using formula
I want to use a Flag column to mark high-priority tasks and calculate a reduced lead time. In a Due Date column I use a formula to add 7 days to the Received Date. I want to change the formula so that it adds only 5 days IF the flag is checked. I can't seem to find out how to reference the value of the flag cell, though.…
-
CountIF "No" or Blank
Hi Smartsheet community, Trying to create a formula that counts the number of cells that are blank or have "No" in them. It is a dropdown column with only two choices, "Yes" and "No", so I tried =COUNTIF([ColumnName]:[ColumnName], <> "Yes"), but that gives me 0
-
parent $1 less than the sum of its whole number children
Does anyone know why a parent would be $1 less than the sum of its whole number children?
-
Descendants vs Children
How can formulas be run against all Descendants of a Parent row, rather than only direct Descendants (Children)? Example: =SUM(DESCENDANTS()) Thank you.
-
Multiple dropdown list driven by previous choices
How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the property that was chosen in column one. Chosing a different property in column one changes the list to choose from in column two.…
-
countifs with specific data set and dates
I have a column with specific criteria (Sample type) and date column. I have another formula that looks specifically for a "sample type" and specific "factory". The formula I've used for this is: =COUNTIFS($Program$3:$Program$333, "Fall Tabletop / Decor", $[Sample Type]$3:$[Sample Type]$333, "DEVELOPMENT + ARTBOARD"). This…
-
RYG Ball Help!
I am driving myself crazy as I know I'm missing something really simple for this RYG formula. I have an actions completed column that could be anywhere from 0 to 100% complete based on 5 tasks that need to be completed. I have setup the RYG column with this formula below and it's not working. Please help me..what am I…
-
Calculate % complete based upon start and end dates?
Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
