-
Pulling data from another sheet based on two criteria
Hello! I am having trouble getting this formula to work.. The goal is to pull the quantity of an item from a reference sheet to this sheet if the Spec #@row on this sheet matches an EAN on the reference sheet, and only if the Disposition value reads "Released". This is the formula I have cooked up, but get an…
-
Count for multiple values in a range
Hello, I'm having some difficulty setting up a countif formula for my sheet. I have a long list of barcodes as a range, and I'm trying to count how many times specific barcodes show up in the list. I currently have it set up to count for two barcodes each in separate columns. =IFERROR(IF(ISBLANK(Barcode@row ), "",…
-
Attempting to create a formula to find items assigned to a contact from a drop down.
I hope my title makes sense. I work in a veterinary Setting, I am working to make some metrics for a sheet dashboard and I am trying to get a cell formula to show me how many of a category is assigned to a person. I have been able to figure out the totals per category in my sheet but now I want to be able to see it at the…
-
Create a sheet summary, which counts RAID items and their statuses from another sheet
Hi there, I have a RAID log called "Work Allocation RAID Log" and I would like to create a Summary Sheet so I can see all the types and counts based on status - please see below Type (primary): Action Decision Dependency Issue Risk - with their statuses (columns): Not started In progress On hold Completed Cancelled This is…
-
Need help with IF AND statement using symbols
I need help with using symbols with formulas. The column property is set to symbols. My current working formula is: =IF(TODAY() > [Remedy Deadline]@row, "Red", IF([Finding Status]@row = "Finding is Closed", "Green", "Yellow")) However, my first IF condition needs to satisfy two conditions: (1) (TODAY() > [Remedy…
-
Adding a "Select-Case" Style Function for Easier Multi-Condition Handling
Hi I’d like to request a new formula feature that allows users to evaluate multiple conditions more cleanly — similar to the Select-Case structure that I had found in a programming language. Currently, we rely on nested IF() functions to test multiple conditions. While this works, it becomes extremely difficult to manage…
-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Formula VLOOKUP or maybe an alternative solution
Hello, I am trying to develop a formula that will reference another sheet and bring back the content from a specific cell. Need to reference two columns for the match in the reference sheet. The match component will come from a column [PI or Account #] on the main sheet to be searched in column 1 on reference sheet and…
-
Having an Issue where I am doing a duplication check and what to email the duplicator email back
Hi, I need help figuring out a method to emailing a set of duplicate emails once. I have an intake for that records emails. If there are duplicate emails in the list of emails, I would want to email them back to tell them that they just submitted a duplicate email. However, The way i have set it up now, sends the same…
-
Forms data entry options
Hi all! I'm wondering if it is possible to create a drop down in Forms that will connect to a specific column. Like, if someone selects Project A from the drop down menu and enters 4 as the number of hours worked on Project A, that 4 would populate a cell under the column for Project A. I have folks who work on multiple…