Discussion List

  • Sharing only certain data for edit on sheet.
    In Using Smartsheet
    Hi,  I got 5 sales reps that all log their new customer in rows on a master sheet. Each row has an assign to column for each sales rep. How could I share this sheet to each one of the sales rep so that they can only see their customers an…
    107 6
    107 views 6 comments Most recent by Steve Rieger Using Smartsheet
  • Dropdown list - Update from the dev team ?
    In Apps, Integrations, and Add Ons
    Hi everyone,   TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used...   I'm using Smartsheet more and more to provide s…
    324 8
    324 views 8 comments Most recent by Andrée Starå Apps, Integrations, and Add Ons
  • Move Rows to Another Sheet...that contain formulas
    In Formulas and Functions
    Hello!  Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved ov…
    508 6
    508 views 6 comments Most recent by Will Sargent Formulas and Functions
  • RYG Arrow Colors
    In Using Smartsheet
    I would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down.  This is helpful for budgeting in project management where at a quick glance you can see …
    75 2
    75 views 2 comments Most recent by Del Horne Using Smartsheet
  • Overlapping Labels on Bar Charts
    In Apps, Integrations, and Add Ons
    I am using a stacked bar graph in order to show a breakdown of projected costs and where they come from. However, when using Data Labels, the totals and highest portion overlap. So far I have not been able to find a way to move labels arou…
    505 3
    505 views 3 comments Most recent by Marco Altamirano Apps, Integrations, and Add Ons
  • New Sheet -- Announcements Message
    In Using Smartsheet
    Hi, Is there a way to have a welcome screen or alert come up when a person goes into a sheet. I would like the sheets comments to pop up on new sheets or like an announcement on already existing sheets.
    124 2
    124 views 2 comments Most recent by Brianne Laird Using Smartsheet
  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    162 3
    162 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Form Confirmation Options
    In Formulas and Functions
    I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
    1370 4
    1.4K views 4 comments Most recent by Debbie Sawyer Formulas and Functions
  • Calculating costs for a task over more than one month
    In Formulas and Functions
    I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, …
    Answered - Pending Review
    228 2
    Answered - Pending Review 228 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Does Smartsheet allow the calculation of IRR?
    In Formulas and Functions
    I have found a key element of Program Management that needs solution in the Smartsheet platform. The calculation for IRR is critical component and not available as general function. As you may know, this simple one varying net cash flow ty…
    255 3
    Answered ✓ 255 views 3 comments Most recent by Michael Mather Formulas and Functions