-
Formula help
I would like to create an equation to count based on specific criteria. The attached image is my criteria. Currently my formula is: =COUNTIFS(CONTAINS("", {Project Clean Slate Case Management Range 1}) + CONTAINS("", {Project Clean Slate Case Management Range 2}) {Project Clean Slate Case Management - Status}, "Waiting on…
-
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"…
-
Formulas in Form
Is there a way to inset a formula into a form to calculate the cost of something depending on what the user selects?
-
Return minimum result from multi options not first
Hello, I have 2 sheets collecting data, both sheets use a unique PRF reference number (which I use for match purposes), I need the look up to return the earliest date from the Book 1 Range 1 data, where the PRF numbers match more than once on the sheet. Currently it will only return the first option it finds, as you can…
-
COUNTIF Date in the next 30 days without counting blanks
I am using the following formula: =COUNTIF([Contract Expiration Date]:[Contract Expiration Date], to count how many are due in the next 30 days. The formula is returning 34 results but if I filter on the same criteria of date in the next 30 days, I only get 5. Is my formula counting blanks? If so, how do I correct to not…
-
Sending Weekly Email with a Filter in Contacts Column
Hello, I'm trying to find a way to send 1 weekly email to each person in a column with a list of all rows that are assigned to their name. I've looked at setting up an automation, but will this send 1 email per row with their name on? And will you have to set up a new one for each contact? Thanks, Eddie
-
How can I make my Grids auto-update in the background to keep my Dashboards up to date?
I've encountered an issue with a system i've put together of grid data that is shown on a Dashboard via Metrics. In one instance I've got a 'Last tested' date that has conditional formatting in the cell that make it change background colour from Green to Red once it exceeds a certain number of days, indicating that a test…
-
Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
-
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…