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 i…
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 indiv…
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 …
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 qui…
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 Na…
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 help…
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. Thi…
Hello all! I have a formula that is stumping me - I am looking to compare a target due date versus the actual completion date. I have a formula that is partially working, but am running into issues wh…
Bit of a complex one: Let's say I have a sheet named "Additions To Scanning Workflow" (with a select number of users) that includes 13 columns of data, one column ("Ready for Digitization Dept.") that…
I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall …
