-
Best practice / ideas for dealing with recurring task reminders
Hi, I'm creating a sheet which will contain a list of about 200 tasks. These tasks are all recurring, although not with the same frequencies. Some need to take place annually, some are quarterly, some monthly (and not always on the same day of the month). I need to create some way to track whether tasks have been completed…
-
Combining Multiple IF AND Statements
Hello, I am trying to combine the 3 statements into one. They all work independently however, I am missing something when I try to combine them. These each check a checkbox if the statement is true. Help Please! =IF(AND([Trans date falls w/in Black-out Period]@row = 1, [Covered Person?]@row = "Yes"), 1, 0) =IF(AND([Covered…
-
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…