-
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…
-
CountifS based on a multi select column
=COUNTIFS({CTC Business Sales Specifics}, FIND("Contract Renewal", {CTC Business Sales Specifics}), {CTC Business Sales Sold Month}, Month@row) Basically, trying to calculate a count from another sheet. If sale specifics has "Contract Renewal" in it, I want a value. The rest based on the month works fine, but I can't get…
-
Message Column Formula Syntax error
Hi folks, I've needed to extend a formula to add in a lot more people under more conditions. I'm getting the syntax error but I don't think it's the quote marks and the column that the formula is in is definitely 'text/number'. Currently, there's a formula with 5 IF statements that works with no issues with each statement…
-
Formula to copy parent data to child
Working with Tasks and SubTasks I dont always have SubTasks but when I do, I'd like to bring data from the parent to the child row. Can this be done with a formula?
-
Vlook up
formulas are not my strength in SS. What would the formula look like for the below use case... I want to grab the date from when an agency was notified about an event being approved and the date when the agency contacted our sales rep about it from the form sheet into a schedule summary sheet with other relevant info.…