-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)
Hi All, I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Service 2, PM Service 3, Oil Change, etc.). For my source sheet, I'm using a repair and…
-
INDEX COLLECT or VLOOKUP not working with numbers
I am in need of some help with trying to use either the INDEX/COLLECT or VLOOKUP functions. I have tried everything I can think of and nothing works. By employee number, I want to return their tenure. Both are contained in a reference sheet. Here is what I have tried. =IFERROR(INDEX(COLLECT({Tenure }, {Employee Number},…
-
Returning data from another sheet matching on two criteria
I am trying to create a report which brings back the actual performance for performance measures for the last month, 2 months ago and three months ago. But am stumped as to how i can do a lookup to the base data sheet using two criteria (MeasureID and where the date is last month etc.) The base data sheet has a row per…
-
Join collect with other sheet
I'm trying to use the best formula that will basically say.. If Distributor Name (sheet one) = Distributor Name (sheet 2), then input contacts (sheet 2) into contacts (sheet 1). There are multiple contacts on separate rows for each distributor on sheet 2 that I want to combine in a single cell for each distributor on…
-
Form Data
Hello totally new user to Smartsheet and need help on creating a form. I have looked at the posts but haven't found the answer, please help. 1) I need to create a form that will be filled by users to sign-up for different games. On the form my first drop down is Venue and that's the easy part, however when they select the…
-
Dashboard Reporting Logical Filtering
Hello, I am currently devolping an Automated Dashboard Template that may function as a Site Visit Report. The project consists of developing thousands of Site Visits Reports, hence the need for an automated system and data entry. I developed a Grid and Form that will be a user-friendly tool during each site visit. However,…
-
VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is grouping all of the addresses based on which group they are in, so when you copy the Email…
-
COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
@Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, which he then is asking for the most recent update of that selected customer. I am…
-
Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL
As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row. ---------------------- Use Case: I leave a comment on Row 1. Row 1 is named "Product Plan". Within the comment on Row 1, I'd like to quickly refer to row…
-
Mark an old submission
Hi, I have a sheet I created where a name and status are being inputted through a Smarthseet form. I am trying to figure out a formula to mark old submissions. Meaning if someone submits a name with the status of "Onboarding" and then submits the form again with the status "Hired", what formula can I use to mark the old…