Discussion List

  • Vlookup from Excel to Smartsheet
    In Formulas and Functions
    My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and cit…
    1031 1
    1K views 1 comment Most recent by Alejandra Formulas and Functions
  • How to index + match with multiple criteria ?
    In Archived 2017 Posts
    Hi!   I'm trying to figure out how to do the following excel formula in Smartsheet, but I am having trouble with it. Can I get some help please ?   Basically what I need to do is match 3 different criteria (lookup 1 -3) with 3 differen…
    3293 16
    Closed 3.3K views 16 comments Most recent by Andrée Starå Archived 2017 Posts
  • Cross-Sheet Reference Limit
    In Formulas and Functions
    Concerning the current limit of 25,000 total cross-sheet references per sheet - is there an easy way to determine how many are currently being used on any given sheet? Thanks!
    64 1
    64 views 1 comment Most recent by Alejandra Formulas and Functions
    In Using Smartsheet
    Hi, I am interrested to know if we can filter on report on mobile apps. I explain, on computer we have the possibility to choose filters by Where, Who, What, and/or. It is really helpful to have an activity follow up linked to many sheet…
    138 1
    138 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Question: Can you identify the worksheet behind a form?
    In Using Smartsheet
    The subject really says it all. I know I can go into a worksheet and identify the forms created for it, but can I do the reverse or do I simply have to check every worksheet until I find it?
    21 1
    21 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Search for Hyperlink
    In Using Smartsheet
    Is there any way to search a sheet for a URL, if it is included in a hyperlink? The URL does not appear on the sheet, the text for the hyperlink does instead. I tried searching, given a URL, and its not finding anything on my sheets. Any …
    46 1
    46 views 1 comment Most recent by Alejandra Using Smartsheet
  • Table of contents in a large sheet; use of forms
    In Using Smartsheet
    hi,  I use one large sheet to manage many different legal tasks across my team (1,000 rows currently). The sheet is divided to many sub sections/categories, main tasks, sub tasks etc. Wanting to add a new main task to a category, the user…
    295 6
    295 views 6 comments Most recent by Andrée Starå Using Smartsheet
  • Criteria need for a "is one of" filter
    In Using Smartsheet
    When making a filter using the condition "is one of", how do you separate the options in the criteria? I have tried commas, semicolons, quotation marks and parentheses.  None are working. 
    107 3
    107 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • If, Then Formula
    In Formulas and Functions
    Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information…
    56 4
    56 views 4 comments Most recent by lisarae723 Formulas and Functions
  • Search, If & Input
    In Formulas and Functions
    I've been having some difficulty trying to solve this one: * I have a master sheet where forms are inputted * For each row there are two columns I need to set up in an IF for, and one where I need a value inputted from another sheet * I i…
    28 3
    28 views 3 comments Most recent by Paul Newcome Formulas and Functions