-
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…
-
Formula referencing cell in newly submitted row
Hi all, I fear this may be impossible, but it's always worth asking. I have a simple time logging sheet with a web form that just asks what project a user is working on. I have system columns use the time stamp from the web form to log the time. I am trying to use the difference between the submitted time and the last…
-
LOOKUP & MATCH together
Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…
-
Does the autofill formula feature not work on project sheets?
When I create a blank sheet to test the autofill formula feature, it works well. However, it does not seem to be working on my sheets that are project sheets. Anyone have any insight on this?' TIA
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
