-
COUNTIFS and Duplicate Values
Hello! I need to figure out a way count the number of records in my issue log, EXCEPT if the records have the same parent number, they can only be counted once. Is there an easy way to do this? Is there a way to use the DISTINCT formula in the "Parent" column, but also count the blank rows, as long as the Record column…
-
Find middle number using LEFT and RIGHT Formulas
I have a column with dates that look like this 2022-10-18. I am trying to create a formula using LEFT and RIGHT to only give me the month (in this example = 10) Please help, thanks!
-
Formula question for Month Data
I need some help figuring out a formula. Wanting to sum up the amount of trainings each person enrolled in the month of April. Can't seem to figure it out. Here is what I am trying: =SUMIF([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", ([Start Date]:[Start Date], MONTH(@cell)4)
-
Formula help
From my sheet I need to populate a checkbox based on these criteria VDate is less than WDate AND Status = Live This formula is working to accomplish the first criteria but I can't get the status part to work. =IF([VDate]@row < [WDate]@row, 1) Thanks for the help, I am horrible at formulas!
-
Average of column if dates meet certain criteria
I'm looking for help on a formula to calculate an average of a column if the date in another column falls between the nominated start and end date. I tried a few different formulas which came up with #UNPARSEABLE, and this one: AVERAGEIF({Date Completed}, AND(>=[Start Date]@row, <=[End Date]@row, {Number})) resulted in…
-
Updating current formula from counting days to counting business days
Hello! I have been tasked with creating a formula that looks at the request type (drop down) and based on that, adds a certain number of business days to the request submitted date to give a completion date. There's 6 options, I was able to make the formula just with regular date counting, but now I need help in adding in…
-
INDEX/MATCH with a HAS Function for Multi-Select Column
I am trying to create an INDEX/MATCH where the INDEX is a Checkbox column and the MATCH is a multi-select column. I am not sure how to incorporate the HAS function for the multi-select column. I would like the High Priority flag marked if any/1 or more of the Sites Under Consideration are flagged a High Priority in the…
-
Combine 2 sheets into one
I have 2 sheets, one with customer location data and one with parcel attributes. I would like one sheets that has the data from both sheets using the parcel number to match the information. (It is listed as Parcel # on one sheet and External System Link on the other sheet.) I am not even sure how to attempt this. Is it…
-
IF Index/ Match Return Yes or No
Hello, I am using the below to return Yes or No as true or false matches. I am looking to Confirm if the Contact listed in [Requestor Contact] is also listed in range {Covered Persons List Range 3}. However, It is returning Yes across the board. My range covered 2 columns both in text. Do I need the range to be formatted…
-
Use countifs to count all projects with a quarter date and year from a date column
my current formula is =countifs({sheet reference}, ROUNDUP(MONTH(@cell)/3) = "4", {sheet reference}, Year(@cell) = "2022" I have ensured the column from the reference is a date column, however I am given invalid data type as an error