-
Dashboard refresh
My sheet gets data from a form and update requests, it rarely needs to be opened directly. I have reports for open items and completed items. I have summary fields in the sheet that count and calculate late items. The Dashboard has metric widgets that look at the summary fields and two report widgets. The dashboard doesn't…
-
How can I count distinct values under a same month?
Hi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this case I would only like to count the unique TR ID's for the month of August, 2020…
-
Added date column not changing
Hello all, I am having a problem when using the added column in Auto Number/System type because today I added a new line and the date did not change. Can you assist me? thank you
-
help with Countif
Hi I am trying to get a formula working for countif, BACOP Visual Fails, so that it looks at BACOP Serial number and then other fields and it will give me the total number of fails
-
RAG Range Formula?
Hi I have a RAG legend which looks like this-: 0-49% = Red 50-79% = Amber 80-100% = Green Like below I have a formula on my sheet which calculates a percentage on a monthly basis. I want the percentage to show in the next cell the relevant RAG e.g. 82% would be green or 55% would be amber. What is the best functions to use…
-
Calculate progress towards a goal
I'm looking at two things - one to highlight when a goal is not on target to complete by a date. The second is note a specific amount in a cell on a certain date. To clarify on the first - I need a formula that will tell me if the number in the Target AUA cell is not going to be meet by the date next to the 90 days cell…
-
Need help with COUNTIFS formula
Hello! I have 2 fields, "Confirmed" (checkbox) and "Status" (drop-down values) to evaluate. In a 3rd field "# Waiting to be processed", I need a formula to return only the count of those records where "Confirmed" is checked and the "Status" field is blank which means "Status" has not been assigned yet Essentially, this…
-
How does COLLECT() with String Criterion Work?
I have a simple formula (I thought) that seems to broken. It seems to be centered around the existence of a String in the Criterion Parameter of COLLECT(). Formula: =IF(MIN(COLLECT(Date:Date, [Work Type]:[Work Type], "Mandatory"))=Date1, Hours1-6, Hours1) Result: #UNPARSEABLE Is it not possible to have a string Criterion…
-
Parent Health Status of Children Rows Based On If Certain Criteria Is Met
Hello, I have a Gender column with these options: Female, Male, Transgender, Non-binary/non-conforming, Prefer not to respond I need the parent row to reflect a status of RED ball if there is no 'Female' represented in any of the children. I currently have this formula, but feel I'm missing significant COUNTIF references:…
-
How to display a date from the sheet
Hi everyone, Does anyone have experience in making a date display in a date format within the Sheet Summary. I have tried to use ISDATE, DATE, and DATEONLY to no avail. I am creating the dashboard for this sheet. I want to display the Kick Off Call Date but I cannot get the date to display These are my results I want the…