Discussion List

  • 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…
    549 5
    549 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Auto inputting a date based on a status change
    In Formulas and Functions
    Hi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me.  Is ther…
    47 6
    47 views 6 comments Most recent by Mike Wilday Formulas and Functions
  • Proofing - Office Documents
    In Using Smartsheet
    Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
    312 10
    312 views 10 comments Most recent by DEW Using Smartsheet
  • Vlookup on reports
    In Formulas and Functions
    Hi I'm using a report to pull together a number of different sheets.  I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup?   Thanks  
    641 7
    641 views 7 comments Most recent by Christina Lam Formulas and Functions
  • Sum Column Divided by Two Summed Columns
    In Formulas and Functions
    This is the formula I'm using, but I'm getting unparseable: =(SUM([Actual final door count]:[Actual final door count])) / SUM([Inspection & minor repair labor hours]:[Inspection & minor repair labor hours] + [Repair labor hours (r…
    34 3
    Accepted Answer 34 views 3 comments Most recent by Mike Wilday Formulas and Functions
  • 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
    979 11
    Answered - Pending Review 979 views 11 comments Most recent by Reni Viessmann Formulas and Functions
  • Auto Save
    In Using Smartsheet
    I just noticed that all of my sheets are  now auto saving. When did this start? Not sure if this is a good thing or bad thing.
    3594 4
    3.6K views 4 comments Most recent by Steve Lyman Using Smartsheet
  • Days Lapsed/Column Formula
    In Formulas and Functions
    How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it s…
    15 1
    Accepted Answer 15 views 1 comment Most recent by Mike Wilday Formulas and Functions
  • Date updating to Next Day using Index, Match, Max, Collect Formula
    In Formulas and Functions
    Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…
    Answered - Pending Review
    261 4
    Answered - Pending Review 261 views 4 comments Most recent by Robin Poppsinger Formulas and Functions
  • Project planning for an Agile development
    In Using Smartsheet
    Hi,  I would like to understand how do you prepare a project plan for an Agile software development. I understand that first the product backlog needs to be created containing the list of features/bug/enhancements that are needed for the …
    25 5
    25 views 5 comments Most recent by Jibran Ahmed Sheikh Using Smartsheet