-
COUNTIF that will only count child rows when present
This is another slight spin off of another question I had asked. How would I structure the COUNTIFS formula to ignore the parent row if child rows are present? The main formula I am using is: =COUNTIFS({FOLLOW UP Range 2}, AND(@cell > DATE(2021, 1, 1), @cell < DATE(2021, 1, 31)), {Follow Up Contractors}, FIND("ACCURATE",…
-
How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)
We may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days. Where could this be pulling from? Can anyone provide some direction? See Row 18 in the attached screenshot. Thanks! Des
-
Count+Distinct
=COUNT(DISTINCT(CHILDREN())) I using the formula above to count the distinct number of bays for different shipments, some shipments would have all of the bays in one cell. Is there a way to modify this formula to count the bays within one cell separately? (for clarification the example above would be 3 distinct bays while…
-
Pulling information based on dropdown selection
I'm pulling information from 1 sheet into another to be used as a dashboard reference and i'm having trouble with a formula.. I need to collect names if "awarded" is selected in a separate column's drop-down. Is there a way to do this?
-
AND(OR Statement Help
I'm getting stuck on this one. I have a working OR statement formula based on no information from two different columns. I want to add a third variable based on another column having a specific statement. I've tried this a few ways but, nothing has worked. Working Original statement: =IF(OR([ePRG Training]@row <> "",…
-
Getting multiple Fields from 1 row using MAX and COLLECT
I have a sheet (IDF Check) that contains static information about my IDF's that I want to use as a kind of dashboard. I have a second sheet (IDF Checklist) that collects information from weekly checks on the IDF including Date and time checked, the inspectors name and a calculated field of the overall status of the IDF.…
-
Looking for a formula to create a unique key
I'm looking for a formula such as MD5 to create a unique key where one does not exist naturally in the worksheet data. When combining two or more columns a unique value is possible, but it would be great to have an formula to calculate a representative vale.
-
countif help
Hi Folks hoping i can get some assistance I have a large tracker that is tracker COVID isolations and test results. i have made a "Summary" sheet that is designed to create a value to display defined information on a dashboard I made a Weeknumber helper column, the week number will generate if - Positive is checked and…
-
Two new PPM Functions: Successors and isCritical, available now!
Hi Community, We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical. The Successors function (type: numeric) allows users to calculate the direct successors of a task and return a collection of values that will occur as a result of the referenced task.…
-
Issue with Index Collect Formula
Looking for help! We collect form responses that load onto this sheet below the KPI section. I need to see, at a glance, TODAY'S responses in the Reporting Data section. So I'm using an INDEX COLLECT formula to pull in today's response from each team member. However, I am getting the errors as shown below. I simply want to…