Sheets

Discussion List

  • How to create an Index Match Formula for multiple sheets?
    In Formulas and Functions
    Hi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns that it will look at. A "TIDC"…
    Accepted
    15 2
    Answered ✓ 15 views 2 comments Most recent by nlarson_PMC Formulas and Functions
  • Index Match Across Multiple Sheets
    In Formulas and Functions
    Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX(…
    Accepted
    19 3
    Answered ✓ 19 views 3 comments Most recent by MVP OPS Formulas and Functions
  • How can I use VLOOKUP to find data from multiple sheets and combine it in another sheet?
    In Formulas and Functions
    I have an existing database of suppliers/vendors set up in a sheet, and I'd like to automatically show if they're currently working on a project and which project they're currently working on, as well as the dates they're working on the pr…
    Accepted
    86 10
    Answered ✓ 86 views 10 comments Most recent by MJ0013 Formulas and Functions
  • Rows Reordered
    In Using Smartsheet
    Our sheet is used as a chronological order of events. Often when others are working in the same sheet, everything gets set out of order. I know Smartsheets does not support autosorting outside of reports. However, it would help if I und…
    Answered - Pending Review
    32 3
    Answered - Pending Review 32 views 3 comments Most recent by marc4 Using Smartsheet
  • Merge 2 column names from separate sheets into one in a single report
    In Using Smartsheet
    Hi I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. H…
    Answered - Pending Review
    23 4
    Answered - Pending Review 23 views 4 comments Most recent by MVP OPS Using Smartsheet
  • Automatically move rows within a single sheet
    In Using Smartsheet
    I pulled a template for a Team Productivity Hub (https://app.smartsheet.com/b/publish?EQBCT=f29e0f2c058f4563853d6497ce554bcc) from the solution center and the sheet for tasks had originally moved completed tasks to the "completed"…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Karina Using Smartsheet
  • Need help with seeing if a cell contains the quote symbol.
    In Formulas and Functions
    I want to locate " in a cell but Smartsheet wont allow me to run the following: =IF(CONTAINS(" " ",[Column]@row),1,0) Is there some sort of symbol that will allow me to reference this in the quotations of the formu…
    Accepted
    16 2
    Answered ✓ 16 views 2 comments Most recent by Joe M. Formulas and Functions
  • AND statement in smart sheet
    In Using Smartsheet
    I am having issues getting results back when using AND statement I am trying to compare two conditions, and show if an action is late or not using the following formula I want to say if the End date is before today and the completed is b…
    Accepted
    17 4
    Answered ✓ 17 views 4 comments Most recent by TDXEV Using Smartsheet
  • Trigger Issue
    In Using Smartsheet
    For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number o…
    Accepted
    39 3
    Answered ✓ 39 views 3 comments Most recent by MVP OPS Using Smartsheet
  • Assigning an auto-number
    In Using Smartsheet
    Hi I have a sheet that is populated via a form and if questions are answered in a certain way it copies cells to another sheet. Once the row has been copied to a the other sheet I have other update workflows that are triggered. The problem…
    Answered - Pending Review
    19 6
    Answered - Pending Review 19 views 6 comments Most recent by brianw Using Smartsheet