-
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…
-
If two conditions are met, then copy the value.
Hi Smart Team, I have two sheets A and B, both sheets have similar columns and metrics from two different systems, I want to create a third sheet and collate data as per condition such as if Date=Date and Queue=Queue then copy date for that day. I was able to gather data from System A, from System B, I'm not getting the…
-
Create Running Average
I need to create a new column with a running average based on the duration column, sounds simple, right? NOT! The issue is the data. In the screenshot below, shows the first section. In this instance the 2nd record shows the end date that happened first. So, as a result, that running average would be ONLY that one record.…
-
COUNT AND SUMIFS ... TO NOT INCLUDE CERTAIN CRITERIAS
Hi, I am wanting to =countif({Postcode 2}, does not contain any of the listed postcodes .... and then the same for a sumif however my brain is not working :( help please :)
