-
CountIF at risk
Hi. I'm having trouble adding the second half of a formula. I am trying to build a rollup task summary. So I need a COUNTIF a task is due within 3 days, and the completed column is blank. I think that will get me to display only the task that is approaching their due date.
-
30 days past due warning
Hi, I need to find automation or formula but not sure which. I have a column of due dates, I need a another column to say "30 days" if due date column is over 30 days past due. Any help is appreciated. Thank you Kim
-
INDEX/MATCH to fix #NO MATCH Errors, when row does not exist
Okay, first, thanks so much for reviewing my question, and posting your potential answer. I really appreciate it! Now I am rather prod of myself, until I got stuck that I was able to create what my boss wanted. There are 2 departments that use this sheet: Transformations and Management. Now when it comes to the 1st phase,…
-
How do I make this formula count blanks?
Hi, How do I make this count blanks? =COUNTIFS({Range 2}, "name", {Range 1}, "30 days", {Range 3}, "Ready Re-insp" {Range 3}, "ISBLANK")) I've tried Range 3}, " ")) Thank you Kim
-
Using MONTH in a formula
I'm trying to pull sales by rep, stage and then add a formula that calculates the current month. I've been trying but failing to get the "MONTH" formula baked in but keep getting errors. My current formula is below - how do I get it to grab the current month from the "Expected Close Date" column in my sheet. =SUMIFS({Sheet…
-
INDEX COLLECT, how to collect multiple values in a range when the criteria matches
I am pulling employee hours from a timesheet to a billing sheet. The billing sheet has a column that pulls the employee name from the timesheet based on the date, project number and cost code. I copy and paste the transactions into the billing sheet =IFERROR(INDEX(COLLECT({Timesheet | Employee Name}, {Timesheet | Project},…
-
Average of duration
Hi, does anyone know if it is possible to calculate the average of data in a column displaying a duration? They are expressed as 3d, 5d, etc. and therefore it won't let me calculate the average as it doesn't seem to recognize them as numbers. Thanks, Barbara
-
COUNTIF Formula for Contact Column
Hello Community, I have a formula setup to count the number of times a contact is mentioned in another sheet, but it is not counting the rows with multiple contacts in the cell. Is there any way we can workaround this to count every time the contact is mentioned, even when it's multiple contacts in a cell? My current…
-
Replacing Cells when row is moved to another sheet?
Here you will see my columns, and my archive (2nd sheet) is the same, i have an automation that basically says when the next recurring date has populated and it is -2 days old to move that over to my main sheet, and that is working for me. My question is, is there an automation or a formula where when it is moved back to…
-
Formula countifs mulitiple criterion?
Hi, I can get as far as (made up example) =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass") but I need to get a third items to be count. For example: =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass", {Range 8}, "ready") Is it possible to search three different columns in a crossheet countifs? Thank you, I appreciate any…
