-
Help with INDEX MATCH with duplicate unique identifiers
Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort name. Records are displayed as: Associate 123456, Cohort 1, Learning Event 1 Associate…
-
Calculating average difference in dates between two columns
Hi I am trying to find the average time to complete a task without adding additional columns in my sheet. I would like to set it up in the sheet summary for easy reporting. In excel I would use the following formula. If a cell is blank the row will not be calculated as part of the average.…
-
COUNTIFS with Due Date and Status
Hi! I've been trying to use a COUNTIFS formula to determine how many projects are 5 days out from the due date, as well as, which projects are either blank or In Progress. I definitely don't have the formula formatted correctly so it is not working. Any help you can provide is greatly appreciated!
-
Form flowing into bottom as child row
Hello I have a parent row on a sheet and I would like new entries that flow into that sheet through a form to be automatically indented so it's a part as a child row to the parent row from the beginning. Also, there is a formula that isn't being pulled down to the new row right away. How do I get the formula to fill in?…
-
Summary
I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. Does anyone know what would be the best way to complete this? Thanks!
-
Recommended Trainings to learn formulas? Beginner to Advanced
Hello! I went to Engage19, participated in all formula learning sessions and have even seen the recordings of Engage18. With this I've just been exposed to possibilities and have applied them by copy pasting the formulas, but I don't really understand the logic of it to actually be able to build my own or think of…
-
Parent vs child flag
Hello, I'm wondering whether it is possible or not to write a formula to indicate whether a certain cell is a parent or a child. The sheet I'm working with only has 2 levels, and I'd like to create a column that is able to delineate the two. My initial thought is something along the lines of =IF([Cell 1] = CHILDREN(), 1,…
-
Trying to count multiple people in a cell
I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. I am using the formula: =COUNTIF({Project List Range 3}, Assigned1) Where Project List Range 3 is the Column in my master sheet…
-
COUNTIFS based on Children criteria of certain row
Context: Please see screenshot attached. Project Manager "Fred" has 2 "active" projects in January: Project 1 and Project 2, which are Children under "Fred". This count of 2 is determined by some percentage of the project being completed. Goal: Count the number of active projects per month based on % complete being greater…
-
Checkmark Parent if any Children Due Date is in the next 7 Days
Hello! Stuck testing out formulas to add a Column [Children Due Soon] that checkmarks if a parent row [Task Name] has any children task is due [Due] in the next 7 days. I've been trying to edit the famous RGB formula for this, but still not very familiar with formulas. Thanks!