-
Trying to get total number of ages
I am working on building a dashboard for QA data. I have a question on the QA Form that asks for patients age. I want to take this and build it into a chart on my dashboard to see how many of each age patient we are seeing in this particular area. Without getting too labor intensive, i.e. one summary line for each age from…
-
Is there a formula to indicate the change in status direction if updated in a given time?
I want to indicate with up/down arrows in a separate column, if the RYG status for a line item has changed direction in the last X days. e.g. if status went from Red to Yellow, Red to Green, Yellow to Green in the last 30 days - show an upward arrow; if status went from Green to Yellow, Yellow to Red, or Green to Red in…
-
Reference Error
Hello, I'm attempting to create formula that references a specific month but for some reason its showing as January 2022 Range 1, when every other column is correctly showing as February 2022 and its providing inaccurate information. Has anyone run into this before and have a fix? Thanks
-
Help creating a report that can select date ranges of information.
Good afternoon everyone! I am working on a traffic counter for a few separate locations. The counter is collecting very basic information: Location, AM visits, PM visit and a Yes/No question. once the form collects the data an automation then moves the input data to one of the four locations own sheet. (MA,TX, China,…
-
How to find the lowest value number in a gap from a sequence of numbers?
Hello! I am currently working on a sheet that will allow us to assign a numbered item to a teammate and keep track of who has what numbered item for traceability purposes. The audit process has been completed and fully automated but I wish to make this more automated during the assignment process. Currently, we manually…
-
I am trying to extract data in an email address.
All the email addresses are formatted as first.last@domain.com Can someone please help me with a function that will extract the "last" from the email? Note: the first and last names will always be different lengths of characters, so i think i need something that will say something like extract after the "." and before the…
-
Multiple IF AND ISBLANK Criteria in Formula
What I'm trying to accomplish: If [Approved] is checked, change [Status] to "Complete" If [Ad RSS Link], [Subject Line], and [Done] are not blank, change [Status] to "Proofing" If [Ads Entered] is checked, change [Status] to "Proofing" If none of the above are true, [Status] will be "Waiting for Information" Here is the…
-
Need a formula to retrieve value from Sources sheet to Target sheet
In Source sheet i have 4 columns: Test ID, Description, Product A, Product B. In Source sheet, If values in Product A and Product B columns are not equal to zero, then i need values of Test ID and Description columns to be retrieved in Target sheet. Source sheet: Target sheet:
-
Finding the average of multiple rows given 3 criteria (Two Sheets)
Context- I am attempting to track the average settlement percentage for a given attorney at an opposing firm with a given client of theirs. In the first screenshot, I've listed that given attorney and their client in columns 1 & 2 (Sheet 1). We are using data from one of our attorney's tracking sheet (Sheet 2). It lists…
-
Countdown to future date not updating when sheet isn't opened
Hi All, I'm using the following formula to add a date countdown metric to a portal. =DATE(2022, 12, 1) - TODAY() The issue I'm having is that it's not updating unless the metrics sheets that I have the formula in is opened. Does anyone have a work around for this? Many thanks, BW
