-
=AVG(COLLECT Formula Referencing Another Sheet
Hello! So I have a master sheet copied into 2 other sheets where people will make updates to in several row sections. I want the master sheet to reflect the averages of what they select in each row section (in percentages) into the master sheet's identical section (sorry if that does not make much sense, not sure how else…
-
Sheet Summary Sumifs with dynamic date range and customer look up
Hi, I am having difficulty with my formulas referencing summary sheet cells. My goal is to indicate a date range in the summary sheet cells, input a customer, and have it a summary cell show the sum of all of the quoted jobs for that customer with in the specified date range. My customers are in a multi check box drop down…
-
Help with COUNTIFS formula
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
-
Need help with a formula!
Hi community, I could use help with a formula. I have a sheet that has all of our Claims data (types, dates, etc) and then a separate sheet that identifies the different claim fees per type of claim. I am trying to have each claim reference the Per Claim Fees sheet to take the type of claim (Auto, Workers Comp, General…
-
Formula returning 'Invalid Operation'
Hello, I'm having trouble with my formula and can't quite figure out how to fix it. =IF(AND([LookUp Value]10 = "Y", {April THD Tech on Call WK1} = 1), JOIN(COLLECT({April THD Tech on Call Name}, {April THD Tech on Call WK1 TOC}, HAS(@cell, [LookUp Value]2)))) Anything obvious that I am missing?
-
Autofill Cells When New Rows Added
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…
-
Multiple email contacts in the IF statement
Hi, I have custom contact list column, which displays email contacts based on the conditions. Here's an example of that column: =IF(AND([Column1]@row = "Value1", OR([Column2]@row = "Value2", [Column2]@row = "Value3")), "email@email.com, email2@email.com, email3@email.com", IF(AND([Column1]@row = "Value5", OR([Column2]@row…
-
Priority Level Based on Whether a Number is Higher or Lower
Hello, I am trying to write a formula that will calculate priorities as such: If Live Count = <15,000 return Critical to Priority column If Live Count = <10,000 return High to Priority column If Live Count = <5,000 return Moderate to Priority column If Live Count = >5,000 return Low to Priority column
-
Automate a response field
I would like to automate a due date of 5 weeks from the creation date unless the status is “On Hold”. Then the date should be blank. When the status changes from “On Hold” to "Open" then the date can be recalculated as above. Unclear how this can be done.
-
Formula says #INVALID OPERATION.
I have this formula in one of my sheets. It was a default formula and it mirrors the rest of the formulas on the page that all work, but it's coming up with #INVALID OPERATION. =SUM(COUNTIF(Priority:Priority, "High") - (COUNTIFS(Priority:Priority, "High", Status:Status, "Complete"))) The Priority column is a symbol column…
