-
I can't get a COUNITF formula to work
I'm new to formulas and haven't done a COUNTIFS formula before. I'm trying to count data from two columns of the same sheet where 1) the date is in the past and 2) a checkbox is selected. What am I doing wrong? =COUNTIFS({Daily Screening MAIN - Sheet Range 1}, < TODAY()), ({Request to be Onsite}, =1)
-
Help with Metric sheet
Hello, I created this metric sheet to get totals for overall performance but I can't get the totals to populate from the sheet that is being referenced. Not sure what I am doing wrong,
-
How to make % frequency chart in dashboard (reasons for QC failure)
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure. "In Dashboard"…
-
Developing existing formula
Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", [Post AFC Change Status]7 = "2. QA Rejected", [Post AFC Change Status]7 = "6. Returned by NR PM", ISBLANK([Post AFC Change…
-
How can I modify this equation?
I am running a report based off a request intake sheet that pulls the 1st choice date and 2nd choice date selected on a form request. This report will be put onto a dashboard and show only available dates (dates that have not been selected as either a first choice or second choice date on a form submission). I have created…
-
Help with month end formula
Hi, I'm building a dashboard to track referral responses. The missing part of my dashboard is I need create a formula that gives the total for each category by month and year. I can't figure out what function I need to add the the formulas I already have to break down the total by month and year. The formulas I've built so…
-
#UNPARSEABLE (Nested IF) - SOLVED
SOLVED! It was a DAU/Picnic error! I was missing the row number after the column name. Apologies, I'm not able to delete/close the original question. ________ I have a column named "Complexity". It's a drop-down list. The options in the drop down are: Rudimentary, Light, Intermediate, Advanced. Might you please shed some…
-
COUNTIF and CONTAINS and OR
I have 2 columns that have multiple select drop down options. I want to create a formula that allows me to identify a PLO and then count the number of times "BE" OR "BC" OR "BL" or "BM" appear throughout the entire sheet. so: =COUNTIF([PLO Alignment]:[PLO Alignment], CONTAINS("A.1 Environment",@cell), Sections:Sections,…
-
Formula to count total number of items selected in a column of multi-select fields
Hi, I have a column called Type, which I've set up as a multi-select drop down. I'm struggling with a formula to count all the items that have been selected. For example, they may have selected 4 responses on each row, but when I created the summary field to do the count on the column, it only gives me the number of rows…
-
Cross-sheet formula with checkbox
Hello all, I am trying to create a cross-sheet summary metrics sheet that counts data based on Status and whether a box is checked. If the "Project?" column check box is checked AND the Status is (for example) In Progress, I'd like this formula to count the number of instances. No matter what I try for the checkbox (true,…