-
Counting number of times a deadline is missed
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it. I need a formula to look at a "date1" column and a "date2" column on a sheet and then I need it to count the number of times the difference between those two dates is more…
-
Parents and Children relationships
I have the following items I need help with: 1) I would like my children rows to automatically display Parent | Task Name For example in this configuration: Parent 1 Child 1 Child 2 I want to see below instead of above Parent 1 Parent 1 | Child 1 Parent 1 | Child 2 So I need to apply a column formula that would do this.…
-
How to record monthly changes in sheet?
So I am trying to get a formula to return a count of the number of cells that match but only if another column that records a date is within the last 30 days. I tried with reports but the issue is they don't display right if I try to send updates in any way besides a link (and I need it to run monthly, weekly, etc.) I felt…
-
Averaging Health Status for Parent Rows based on Average of Children Rows in RYG.
Hi everyone, I am looking to find the best formula to give me the average health status in RYG for the parent rows (#2). I have tried IF formulas but keep getting parsed errors. Please help. Also looking to get the formula to the sub row (#1- where the picture says strategy session or AI POD etc) to the parent as well. Any…
-
Filtering with a formula, but stuck
Hello, I'm trying to filter a summary sheet metric using the following formula but I keep getting "NOMATCH" or "UNPARSEABLE" depending on what I move around. The issue seems to be when I add the Country criteria. I want to filter to just United States and Canada: =SUMIFS([Total employees]:[Total employees],…
-
Nested Ifs to show progress on an assignment
I have three scenarios I'm trying to string together. Each of the formulas works when they're separate but I can't figure out how to nest them correctly. In what order should they be nested (replacing "Test" with the next criteria)? If "Assigned To" is blank and "Actual Completion Date" is blank, then "Unassigned" If…
-
Equation to populate new number
Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last column is how much quantity that person claimed (Quantity Claimed). So for example, if…
-
Auto fill cells based on multiple criteria, using Index Match
I'm struggling with the logic here so any help is appreciated. My team manages new hires and we have to rate their performance weekly to report back to the new hires respective manager. Our program is 10 weeks long and to consistently rate them on the same metrics week to week, we created a survey that the trainers would…
-
Automated Directional Arrow Symbols
I am trying to compared two columns in my sheet, based on if the numbers in the column grew, shrunk, or were unchanged. I'd like to automatically show this with the up/down/unchanged symbol. Is this possible? I was able to get the up/down arrows to automatically show, but I'm not sure how to incorporate the "unchanged"…
-
Force Update TODAY Formulas
Does anyone know of a way to force TODAY formulas to update whether or not the sheet is opened? I'm trying to trigger workflows off of a TODAY formula, but it currently only works if I open the sheet, causing the formula to update. Smartsheet's usage notes indicate that the following events cause TODAY functions to update:…