-
COUNT IFS for Assigned Person
I want to count the number of tasks due within a certain time frame, let's say next 7 days. I have found the following formula to work: =COUNTIFS([Due Date]:[Due Date], >=TODAY(), [Due Date]:[Due Date], <=TODAY(7)) However, I now want to expand the formula so it is only counting the number of tasks due that is assigned to…
-
Generate new row when box is checked
Hello, The sheet I'm using is the back end of a sign-in form for my office. The user selects the week they want to come in and checks a box next to the days of the week. I then have a series of formulas that will turn the checked box into its corresponding date. What I would like is for each of those dates to show as its…
-
Multi-Year Formula
Hello All, I am new to formulas on SS and need your help writing the following formula. In the first (non-primary) column is a date field. (E.g. 3/9/2022) In the second column I need the first col date + 3 years to go all the way down my spreadsheet I am sure this is simple, but I need your help!
-
Combine 2 Index Match formulas to concatenate 2 cells?
I have 2 sheets, each with a column for Subcontract Codes and a String of all the jobs they have worked on. Sheet 1 lists jobs that we had positive experiences, Sheet 2 lists jobs we had negative experiences. I need to combine the job numbers into a 3rd sheet, matching based upon the Sub Codes. I can easily get one list of…
-
Help with COUNTIFS
Trying to count closed cases in a date range, formula won't work: =COUNTIFS({AAA Range 4}, <= DATE(2021, 8, 01), {AAA Range 4}, >= DATE(2021, 10, 30), {AAA Range 2}, "resolved)) Is there something wrong with my formula?
-
Move to another sheet when date is x months old?
Hi, is it possible with an automation or set up a formula to move a row to another sheet after it three months old? I have a date column, but I can't find a way to move it by date. Thank you
-
Formula for requests due in a certain time frame.
Hi, I'm trying to create a COUNTIFS formula for my metrics sheet. =COUNTIFS({Creative Services Tracker Status}, <>"05_COMPLETE", {Creative Services Tracker Status}, <>"06_DEAD", {Creative Services - Requested Completion}, <=TODAY(7)) I'm trying to see a count of requests that are due within the next 7 days that DO NOT have…
-
I need a formula for the below
Hi Team, I'm looking for a formula to tick the RUC Required box if the RUC end KMS are either within 1000km of the Odometer reading or higher. But I also need it to disregard the odometer box and take the HUBO Reading if that cell has a value in it. I use this so once the form is filled out, the formula is applied and an…
-
Add years to a date
Hi, I'm trying to populate a column with a future date. What formula can I use to take a birthdate entry in one column and add 26 years? Seems like a simple enough ask, but nothing I've seen in other questions seems like a plug & play answer to me. Both columns are date field settings Thanks!
-
Can COUNTIFS count on a column with values returned from a fomula?
This seems so easy, so I'm sure I'm doing something really dumb that I just can't see, but I can't get this COUNTIFS formula to work. It keeps returning "#NO MATCH" when I know that there is a match. I'm trying to count the number of times "EOX" appears in the Company column and "Reviewed with CSR" appears in the…