-
Index(Match()) Returning incorrect row
Hello! I'm hoping to get some help in finding an error in my index(match()) formula. I'm trying to pull a contact name for a customer from one sheet into another based on the customer name. The original sheet has customer name and contact email; the sheet I'm trying to fill in has customer name and I'd just want to fill it…
-
Two checkbox columns to drive checkbox in 3rd column.
I have a pair of checkbox columns, which you can check for different criteria. I have a third column, also a checkbox column. I am trying to have the 3rd column be checked based off one of the 2 preceding columns being checked. I tried a formula "=COUNTIFS([Registered (DL)]:[Registered (DL)], 1, [Registered…
-
Restricted Task Dates in Office Timeline Pro+?
I use Office Timeline Pro+ to create all my corporate project timeline slides by importing source Sheets or Reports. Is there a way to show project timelines restricted by a certain date? For example, I want to show all tasks that are in progress as of 1JAN2024, regardless of the actual start date (e.g., if the start date…
-
Counting user login between 30-89 days
The data set tracks each time a user logs in. I need metrics on users who have logged in between 30-89 days, but I only need to count the most recent instance. Also, I am using data shuttle to bring it in, so I'd like to filter out the duplicate emails keeping only the most recent instance.
-
Help with alternative formula to SUM(CHILDREN) for budgets
I've created a budget template that uses the standard SUM(CHILDREN) formula to add the individual dollar amounts for a specific portion of the budget and obviously gives me a total SUM above the individual dollar amounts (purple cell on left). The intended recipient wants to see the total SUM below the individual lines,…
-
Formula to transfer data to a blank sheet
Hi! I am trying to figure out a formula to transfer data from one sheet to another. The old sheet has a "Supplier" name on it. Basically, I want that same name to appear in the new sheet. There is no unique identifier as the new sheet is blank. I'm not sure how to write it out though. Basically, if the "supplier" cell is…
-
Collect most recent date from another sheet based on certain criteria
Hello I have a fleet maintenance log that has invoices per vehicle with a column that is a drop-down with multiple values based on the service provided. I am trying to make a sheet that would be a quick reference to see the most recent service per vehicle per category. Being multiple services will but under a category I…
-
How to count a range of different names from a range of dates?
Sheet A has a week ending date column (always Sunday). Sheet A also has a column called Manpower where I am trying to write a formula. Looks like this, Sheet B Has an install date and an Installers Name. Looks like this, The formula I am trying to write would find all dates from Sheet B that fall within the week ending…
-
TODAY function and status
I'm working a formula for a RYG column based on two major sets of data: Status and Quarter Start Status and Quarter End Q Start and Q End are the dates of the quarter and they are on the sheet as helper columns. For example: If Quarter starts in the next 80-120 days: blank status - Yellow Status is Product discovery,…
-
Exclude a range of values from a source range of values
Hey all, I've got Sheet 1 - List 1 that is an intake sheet with a range of opportunities (each identified by a unique opportunity number with a set number of digits) exported from our CRM program. This sheet is automatically updated whenever a seller puts a new opportunity into the CRM. I am not allowed to make changes to…
