-
SUMIFS giving #INCORRECT ARGUMENT SET
I need to sum up the total wall volumes processed on a given day at a given time. I am using a SUMIFS statement to sum the wall volume when the date matches a specific one, and when the time of day is 3:00 PM This is the formula I have: =SUMIFS([Total Walls]@row:[Total Walls]@row, Date:Date, =[Every Date]@row, [Time of…
-
Need assistance with formula
I have this formula on a column =IF(Status@row = "Complete", "100%", ="In Progress", " %"), I want the user to be able to add in a number when the status@row is "in Progress". How can I write the formula to be able to allow the user to type in a progress level. "In progress" may be 75% or 50%
-
SUMIF? Question
I am trying to write a formula to sum up numbers within the last 30 days in a sheet summary. So my argument =SUMIF([Entry Date]:[Entry Date], ">" TODAY() -30,[House Holds Served]:[House Holds Served]). Honestly I am still very new to formulas and have gone through the Academy online for this step but it is still showing as…
-
COUNTIFS with Multiple Criteria and Dates
I am trying to figure out how many of the cells contain certain practice locations on a certain date. For instance I was to know the amount of orders from BWMG Adult and Senior Care, BWMG Hanover, BWMG Pasadena, BWMG Primary Care North, BWMG Shipley, on 01/05/2024, I have tried various formats for the formula and cannot…
-
Help with Join Collect formula
I have a long list of subcompetencies, that are mapped to course objectives across courses. What I would like like a formula that displays subcompetencies where objectives are equal to "NA", but if the subcompetency is already mapped in a different course to a course objective, then do not display. In other words, i need a…
-
Editing multiple update requests
Is there a way to filter/sort by rows with pending update requests or even mass delete all pending requests? Pulling together a list of pending requests for follow up as well as deleting all stale pending requests before the next automatic occurrence is a real pain!
-
Need help counting the number of unique values in a cell while referencing a second range
Hi! I have a dashboard which contains multiple rows with various study numbers (listed in a Study Number column). Some of the study numbers occur more than once in the column (for example study 12345 is for liquid samples and in another row, study 12345 is for solid samples). Each study number is also associated with a…
-
Create sheet automatically fro template when rows are added
Hi, Need assistance in creating sheets automatically when rows are added on the intake form. Also Department field in intake form has dropdown option of multi-select. Based on the option it has corresponding columns in Template sheet that holds value of yes or blank. When dept 1 and dept 2 is selected . Rows that has dept…
-
COUNTIFS with Dates and Other Criteria
Hello, I am trying to work on a formula that will count if there is a certain date and Practice Location. For instance in the example I am trying to find how many have Family Medical Associates and 01/12/2024. Here is the formula I am using and keep receive the error "Incorrect Argument" =COUNTIFS({THMD CareKit Referral…
-
PMO Template - Deleted header row
Hi guys! I’ve been using the PMO template successfully for a while now, but this morning I accidentally deleted the Header info and now all of the metadata for the projects shows #REF for all of the fields. I tried to recreate it as best as I could, but it’s still off. Attached are what they look like. Normally I’m the…