-
Formula for 1st of the month in a prior month is coming up Invalid Value
I have 3 different formulas for 1st of the month 1 month, 2 months and 3 months before renewal date, excluding holidays and weekends. The formula is working great, until it has to calculate back in a previous year. 1st Follow-Up Email Due Formula: =WORKDAY(DATE(YEAR([Renewal Date]@row), MONTH([Renewal Date]@row) - 2, 1) -…
-
Add Months to Date formula?
I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple. I'm trying to add a certain number (Varying) of months to a start date to produce an end date. I have a start date column (which is a date column), a column that…
-
Merging CountIFS and Contains
Hi all, Trying to get a CountIFS statement to count when a column contains the values "UE" where another column contains a certain animal type. In the example below, the value should be 2, not 0. What am I missing or am I trying to combine the wrong types of formulas? Thank you in advance! Current formula: =COUNTIFS([Study…
-
How to create a flag column that identifies a scheduling conflict
I am trying to create a checkbox column that gets checked when the conditions of a formula are met. Essentially, I am trying to flag a row if someone is assigned to that row who already has an assignment for that same date AND if the start and end times overlap. Example: Interpreter= John; Date= 6/1/2025; Start Time= 8:00…
-
Mode Function
Does anyone know if there is a "Mode" formula yet without using a helper column?
-
Counting Children Rows if marked as Active
Hello, I am trying to list the number of projects (AKA children rows that are marked as "Active" under Active Project/Staff) in the Number of Projects column. The formula I am using where I get #unparseable is =COUNTIF(Children([Active Project/Staff]@row ), CHILDREN([Active Project/Staff]@row = "Active"))
-
SUMIFS Help
I am trying to sum a column with SUMIFs. I have two sets of criteria but am having trouble with the third. I am trying to sum the cost if it matches a project title column, and invoiced quarter column. If the invoice quarter column is blank I want to check if a different column (expected delivery quarter) matches. The…
-
IF FORMULA AND 2 DATE COLUMNS
Hello, I am wanting to capture a date into a current date column if there is a date in the second column. Example: If NEW EXP DATE has a new date, I would like that date to display in the CURRENT EXP DATE column. If there is not a date in the NEW EXP DATE column, then I would like to keep the current date in the CURRENT…
-
I have reached the maximum number of Cross References, is there a way to Index Match an Entire row?
I am working on across a couple sheets where the columns contain all the same info across 7-8 sheets and the individual sheets correspond to different groups of people. I am trying to consolidate all of the info into one sheet that updates with changes to the 7-8 reference sheets. I have been doing index matching for each…
-
Date incrementing column formula works fine except in two cases.
Hi there, I am using a formula to establish future dates (Scheduled Pull-Out Date) based on a starting date (Packaging Date) and adding a number of months according to the 'Time Point' column. The formula seems to work fine until I noticed that two entries (in purple) are not following the rule; they are supposed to add 9…