-
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…
-
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
-
Counting Checkboxes to deteremine Probability
I have multiple check boxes in a row and want to determine Probability based upon how many of the are checked. If 3 checked its High, if 2 Medium one is low. am doing this across sheets, other words metrics sheet that looking at with boxes..
-
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…
-
Issues combining 2 formulas
I have the following columns: Expected Budget, Director Approval, VP Approval, Approved Projects. The conditions being, if Expected Budget is less than $10000, only director approval required, if more than $10000, both director and VP approval is required. On the Approved Projects, I would like to show if the project is…
-
Using JOIN-DISTINCT-COLLECT when values are not same data type
Hello, I am trying to create a string of values delimited with "+"s. It is part of a more complicated sheet, that matches Lot IDs to barcodes and other information from referencing another sheet. Essentially, I want the user to put in a lot ID (such as DXXXX) and the return to be a list of all the barcodes in the format:…
-
COUNTIFS criteria for "anything" in cross-sheet formula.
I've created a complicated cross-sheet formula that is supposed to the number of times the criteria "Mentioned" is found in Range 6 with an "any" criteria for Range 5 so that no matter what is in Range 5, if "Mentioned" is in Range 5, it will count it. This is what I tried: =COUNTIFS({Media Tracking Range 5}, {Media…
-
Calculating time between two timestamps in the same column
We were given some raw data from a virtual server and we need to calculate the session duration between 2 events in the same column and we cant figure it out the idea is to get the date from source table and on a formula sheet have the name of the agent, Date, Session Time start, Session Time End and Session duration Table…
-
Using TODAY function to calculate a half life
I am trying to use the TODAY function to continuously track half-lives of different radioactive material for inventory purposes. For example, if I order 50 mCi of lead 203 which has a half life of 51.8 hours, how can I make a formula to check how much has decayed in two days? Basically, is there a way to make the TODAY…
-
Drop down selection and cell updates
I have a column with drop down single select type name SLC Status. The entries in the drop down are "Requested", "In Review" , "Progress", "Testing", "Completed". There is a separate column for each entity ("Requested", "In Review" , "Progress", "Testing", "Completed"). My goal is- when Requested is selected from the drop…