Consumer Products

 

Discussion List

  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1344 5
    1.3K views 5 comments Most recent by L_123 Formulas and Functions
  • Auto fill a second column based on a drop down selection using a form
    In Formulas and Functions
    I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.  Situation: I would like to have a form where someone selects one op…
    7585 22
    7.6K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • 2 or more projects sheet dependency
    In Using Smartsheet
    HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles.  I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
    1932 9
    1.9K views 9 comments Most recent by CWats716 Using Smartsheet
  • Linking directly to files from a dashboard?
    In Using Smartsheet
    I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files.  Savin…
    3301 14
    3.3K views 14 comments Most recent by Caitlin Swim Using Smartsheet
  • Dependant dropdown lists
    In Using Smartsheet
    Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I have list of 300 Banks with SWIFT codes . One column is Bank name, another column is SWIFT code. I also have a list …
    DIV Profile Photo DIV
    282 6
    282 views 6 comments Most recent by Joachim Mund Using Smartsheet
  • Automatically Track Inventory Usage
    In Formulas and Functions
    I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program.  I'm hoping there's a way to automatically track inventory usage base…
    587 7
    587 views 7 comments Most recent by Alexander Coales Formulas and Functions
  • Import Excel file and include embedded images
    In Using Smartsheet
    Hi,  I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something?   Or do I have to re-import those images manually,…
    175 3
    175 views 3 comments Most recent by slaflen17131 Using Smartsheet
  • Filter View Access for certain users
    In Using Smartsheet
    Hi everyone, I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specificatio…
    611 5
    611 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Is there a way to create a search box?
    In Formulas and Functions
    We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
    Answered - Pending Review
    1093 11
    Answered - Pending Review 1.1K views 11 comments Most recent by Reni Viessmann Formulas and Functions
  • CAPA - Industry Standards (benchmarking)
    In Using Smartsheet
    I am in the Medical Device industry. I am looking for some bench marking information around what  a well rounded CAPA system Metric should look like.    For example: What is the typical percentage of CAPA types in your CAPA System. For e…
    92 2
    92 views 2 comments Most recent by Brianne Laird Using Smartsheet