-
Index/Match not working when the Match column in source doc is a 'RIGHT' formula
I have a column in my source sheet where Store # is a RIGHT formula. When I index match in my Target sheet I get 'NO MATCH' when trying to find Store #.
-
Avoiding Overbooking using Smartsheet Calendar/DataShuttle
Hello! I am trying to create a booking system for a room with multiple stations. Stations: 1 - 5. Time slots: Morning, Afternoon, All Day So far I have a dashboard with a calendar/form and separate sheet for the form submissions. With the calendar, people are able to see other bookings, but ideally, I want to use…
-
Formula for This week, Next week, etc.
Someone helped me with these, but I cant get them to work. Can someone let me know the error of my ways? This formula would be for last week =If(YEAR([Projected Start date]@row=YEAR(TODAY(-7)),IF(WEEKNUMBER[Projected Start date]@row=WEEKNUMBER(TODAY(-7)),1,""),"") This formula would be for this week =If(YEAR([Projected…
-
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…