-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
Does Smartsheets have a Google PERCENTRANK function equivalent?
Hello, does anyone have a solution for the excel / google function “PERCENTRANK()” or the “RANK” function. We want to consolidate our roadmap planning into Smartsheets and use one of these functions to automatically score from 1 to 10 each item in the list. The below image shows how this is done today in Google. The user…
-
sumif multiple criteria
Hi, I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist =SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget") Thanks
-
How to do "OR" in conditional formatting
Hello, I have a column which receives answers from a form. The form is basically a test for nurses. I have conditional formatting set up in the answer column that if the answer arriving is NOT the correct answer, then the cell with the wrong answer turns red. Now the managers decided to change the wording in one of the…
-
Predecessor formula Help
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all…
-
Duration in Hours and Minutes
Greetings, I have certain subtasks under my tasks that only run terms of hours and minutes and not days. Is it possible to capture the duration in that detail ? Or do we need to break down the days in to hours (which seems very tedious). I did find on this…
-
Trying to create an IF THEN function in smartsheet
My example is to select an material size value based on the material. Something like this: If [cell1]="4X8 Sheet" then [cell2]=32, if [cell1]="4X12 Sheet" then [cell2]=48, etc, etc. I have a dropdown list in the materials column to restrict the set of possible materials. Subsequently, I would like to take those values to…
-
Sum if of Current Week +/- 1
I have a formula that will give me the current week capacity: =SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}). However I'm not sure of the formula to capacity for the next week or the past week capacity =SUMIF(@{Week Number}, @cell = (WEEKNUMBER(TODAY()) +7), {Capacity}). I would greatly appreciate some…
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
