-
I'd like to create a column formula that references a specific cell with acceptable syntax
I have a sheet that has a column of dates that autofill based on another date. Specifically, each row has target end dates based on weeks ahead of the date that I want to reference. This is to make sure tasks are started on time in relation to the overall start date. My formula is currently: =[Target End Date]1 - ([Task…
-
Metrics Sheet Doubling values
Hello, I am trying to solve have a cross-reference sheet problem that is doubling my values in my metric sheet. I am using =sum(children()) in my source sheet to sum the values under each parent/child row. When I reference the destination sheet for metrics it doubles the value because I think I am referencing to sum all…
-
How to return a BLANK if we have a BLANK cell using a COUNTIFS formula
This formula is currently working, and it is returning how many items are reviewed for each "Project Lead". The first part of the formula is basically saying that we would count them, as long as we have a "Reviewer" name added in the "Reviewer" column. =IFERROR(COUNTIFS(Reviewer:Reviewer, <>"", [Project Lead]:[Project…
-
How to we exclude a specific name from a DISTINCT LIST USER formula
I would like to exclude a specific user name from this formula. The formula is working fine, and it is returning a distinct list of user names. However, we need to exclude certain users, that are no longer in the group. For example, how do I say to exclude user "Joe Black" from this list? =IFERROR(INDEX(DISTINCT({Trial…
-
INDEX/MATCH/COLLECT How to get most recent entry by person and by most recent date
Good afternoon, I have been spinning my wheels trying to get my formula to work and scouring the community. Hope someone here can help :) I have employees that need to checkout items and they record this by form. My want is to pull the most recent date based on name and whatever item they checked out. Sheet A w/ the form…
-
Incorrect Argument Set
Hello, I don't know what is wrong with this formula. I receive the "Incorrect Argument Set" error. =SUMIFS({Invoice Amount}, {Segment}, "All", {Requires JV}, "Y", {Invoice Date}, <DATE(2023, 7, 1)) Thanks, Amy
-
Formula that counts how many rows have a date in the past
Hi! I need help with creating a formula that will count how many rows in my column called End Date have dates in the past. I've tried the following and it gives an "unparseable" error: =COUNTIFS([End Date]:[End Date], "<=" & TODAY()) Thanks in advance for your help!
-
Help with IF/INDEX/MATCH (I think)
Hi there - I'm looking for a formula that looks at Sheet 2 and if the "Terminated" box is checked, then check the "Not Currently Active" box in Sheet 1, according to the entity name. (Meaning if Happy Co is listed as Terminated in Sheet 2, it would be marked as "Not Currently Active" in Sheet 1. I appreciate any help you…
-
INDEX Formula Not pulling data
I have a master sheet that I am using an INDEX formula to pull data in from other sheets based on a common data element. I am using this on different columns in the master sheet and of the 6 only 3 are working. I know there is a match so the 3 not working should be pulling in. Here are the formulas I am using. Any ideas…
-
How to use COUNTIF function if I am looking to count a contacts type column
Hi there! I am creating a tracker to track initiatives in my group. I have about 8 initiatives listed so far with a contacts column that contains all team members per row. I am looking to count specific names and how many affiliated initiatives they are part of. I have created 2 sheets: #1 Actual tracker #2 To create count…