-
sumifs function combined with NOT
Hi I try to set up a formula the first part is working. But now I try to exclude the not briefed articles in column (active article check). What needs to be adjusted that below formula is working? Thanks =SUMIFS([shipped quantities in pairs]@row, [Article#]@row, CONTAINS([Article#]@row, @cell, [active article check]@row,…
-
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.…
-
Column Formula with different formulas in parent and child
Hi, I'm trying to make a column formula, where the parent cell (level 0) will return 'Delayed' if any child cells have the value 'Overdue' in it. The child cells currently have the below formula in it, which I would like to extend to be able to make it a column formula. =IF([Days left]@row < [Estimated effort]@row,…
-
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…
-
Migrating different smartsheets with data to create smartsheet inventory
Hi, Part of the work (this is a newly created role)I will begin to do is to help my organization create a smartsheet inventory. Different departments have different smart sheets that have different data and are being kept separately. There are about 5000 different smart sheets with different data sets. Some of the data on…
-
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…
-
COUNTIF with NETWORKDAYS & TODAY - Counting Aging Orders in Sheet Summary Field
Hi Folks, I'm trying to set up sheet summary fields to count the number of orders of varying ages in a pending orders smartsheet. As far as I've been able to tell, there's no way to calculate it by hours, so I've settled for "order submitted today", 1 day old, 2 days old, 3+ days old. The problem is that I would like this…
-
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…