-
Reference Predecessor Cell / INDIRECT Function
I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My problem is that I'd like to adjust the formula so that it references a predecessor task (as…
-
COUNTIF formula with CONTAINS not working
I am having an issue when adding a "contains" function to my "countif" function. I am hoping someone can assist. The current formula that I am using works perfectly for COUNTIF =COUNTIF({Import RFI's Range 1}, "ADCVD") When I convert the formula to include CONTAINS I get an INVALID ARGUMENT message.…
-
Index/Match Question, Display Time of meeting based upon the date
Here is my problem: I have 2 standing meeting slots, one on the morning and one in the afternoon. A meeting can be scheduled during the morning, during the afternoon, both, or none. Here is my need: I wanted to show if there is a meeting in either slot on a given day. Right now I can show if one meeting slot is filled but…
-
Dashboard chart for daily submissions (via form) over time
I have a seven week event. I have a form set up for submissions about the event. How do I set up the metric sheet and which formulas to count submissions each day/ week to appear on the chart to show on the dashboard.
-
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.…