Discussion List

  • 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…
    8539 22
    8.5K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • Smartsheet not saving consistently
    In Using Smartsheet
    I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
    1516 12
    1.5K views 12 comments Most recent by Bec Nissen Using Smartsheet
  • COUNTIF Formula for Contact Column
    In Formulas and Functions
    I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that count…
    1631 11
    1.6K views 11 comments Most recent by Genevieve P. Formulas and Functions
  • Extract Image using Index and Match/Vlookup
    In Formulas and Functions
    Hey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't…
    380 3
    Answered ✓ 380 views 3 comments Most recent by Julia Mazza Formulas and Functions
  • 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…
    687 7
    687 views 7 comments Most recent by Alexander Coales Formulas and Functions
  • Issue with leading zeroes when Identifying duplicates
    In Formulas and Functions
    I am using the following formula to identify duplicate invoice #s in a spreadsheet. I've noticed that the formula does not work when the invoice # starts with a zero. It works for all other formats: text, numbers (without leading zeroes), …
    364 3
    364 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Resource view
    In Using Smartsheet
    Can I zoom out on the resource view to show the timeline by month and quarter and not just week, which is the default?
    63 3
    63 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • *NEW: Proofing using Reports
    In Using Smartsheet
    The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
    646 34
    Answered ✓ 646 views 34 comments Most recent by Andrée Starå Using Smartsheet
  • Cumulative Expense Column for budget restraint checks
    In Formulas and Functions
    Hello  I need to have a running total expense column on my smartsheet for budgetary checks. Can someone help me with a solution please? I would like a column that updates with a cumulative $ after I enter an expense amount in another exis…
    322 5
    322 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Update Confirmation email limitations
    In Using Smartsheet
    Has anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change t…
    315 2
    315 views 2 comments Most recent by Caroline Sheldon Using Smartsheet