-
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…
-
COUNTIF substring or wild cards
I have a column of Part Numbers. Each cell in the column may have a single part number or comma separated part numbers. I want to count the number of occurrences of a particular part number in the column. I searched the help and community pages but wasn't sure what's the latest. Is it possible to use wild cards or any…
