Discussion List

  • Adding detailed information to a row / task
    In Using Smartsheet
    I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did the customer request, how do …
    15 0
    Question 15 views 0 comments Started by delberto Using Smartsheet
  • Automating document creation
    In Using Smartsheet
    I am trying to automate a workflow with Smartsheet. It starts with a large survey (external to Smartsheet--Forms can't handle the requirements), whose results are inserted into a Sheet. Whenever a new row (survey result) is added to that …
    Answered - Pending Review
    4185 26
    Answered - Pending Review 4.2K views 26 comments Most recent by Paul Spankie Using Smartsheet
  • Need formula to pull in names associated with RACI roles.
    In Formulas and Functions
    I have a Project Plan template that I would like my team members to save as new for each client and customize the information. Within the Project Plan, there's a RACI matrix with different roles. Please see below for an example: When a ne…
    38 2
    Answered ✓ 38 views 2 comments Most recent by rmc0030 Formulas and Functions
  • Is it possible to disable sorting in Dynamic View?
    In Apps, Integrations, and Add Ons
    I want to disable sorting in Dynamic View to prevent users from messing with the data order. How can I do that ?
    17 3
    Answered ✓ 17 views 3 comments Most recent by Stephanie Reedy Apps, Integrations, and Add Ons
  • % Complete Column
    In Using Smartsheet
    Anyone else having issues? I cannot update this column in any of my sheets. It just jumps to the next line of it you hit return it auto adds a full line.
    Answered - Pending Review
    8 3
    Answered - Pending Review 8 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Add Column to Row Report that was not in original sheet
    In Using Smartsheet
    Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. T…
    Answered - Pending Review
    946 8
    Answered - Pending Review 946 views 8 comments Most recent by rvogler Using Smartsheet
  • simple sumif formula not working
    In Formulas and Functions
    Hello, I am doing a cross sheet formula with a SUMIF. =SUMIF({CLONE BATCH ID}, [CLONE BATCH ID]@row, {CLONE CUT QTY}) I am repeating the formula I have used in other sheets. I re-watched the formulas video and am doing everything exactly …
    Answered - Pending Review
    22 11
    Answered - Pending Review 22 views 11 comments Most recent by Sarah_lee123 Formulas and Functions
  • CONTAINS with Trigger Search
    In Formulas and Functions
    Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device …
    Answered - Pending Review
    28 6
    Answered - Pending Review 28 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Using sumifs to tally up certain date ranges
    In Formulas and Functions
    Hi All. I'm working to understand the more complex formulas of smartsheet but have been stumped. I'm looking to sum the work area total amount of a task based on the start and finish dates on the Gantt chart. I want to see what we will bil…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Paul Newcome Formulas and Functions