Using Smartsheet

Post a question about using the core Smartsheet application: sheets, forms, reports, automation, dashboards, and more.

Discussion List

  • How do I extract the left most word in a Column?
    In Using Smartsheet
    I'm looking for a formula to extract the left-most word form a column that will have different character lengths. Looking at the example below: Sometimes there is a / in front of that left-most word Sometimes its just a single word Someti…
    Accepted
    23 9
    Accepted Answer 23 views 9 comments Most recent by Paul Newcome
  • How do folks create location specific portals or dashboards
    In Using Smartsheet
    Community; I have 30-40 store teams that need access to the same sheet of information. However, it would be better to have the staff could view only rows that are pertinent to the store they work in. Any ideas how best to distribute that …
    Answered - Pending Review
    9 2
    Answered - Pending Review 9 views 2 comments Most recent by Dale Murphy
  • Formula for referencing two columns in another sheet.
    In Using Smartsheet
    Hello, I would like to add a formula for the partners' cell(image #1) to reference the two columns in another sheet (image #2). The current formula you see in the first image only references the Partners(existing) column. Any help is …
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Paul Newcome
  • Duplicate column into a sheet
    In Using Smartsheet
    Hi all , Is it possible to duplicate an entire column into a sheet ? I thought it would be easy just by " copy and paste " , but it does'nt work . Do you have a solution ? Thanks in advance .
    Answered - Pending Review
    10 3
    Answered - Pending Review 10 views 3 comments Most recent by Paul Newcome
  • My filter keeps expanding all of my parent/child rows upon filter
    In Using Smartsheet
    I want to be able to move through filters without having to collapse all every time. What am I doing wrong?
    Answered - Pending Review
    16 2
    Answered - Pending Review 16 views 2 comments Most recent by dgloballab
  • Is there a way to have multiple people fill out the same form
    In Using Smartsheet
    So I have a form that is filled out partially by the user initiating the form. An alert is sent to the person in the 'Assigned To' field. Let's say the ID on the form is #4. I would like for the assignee to be able to open the form and fi…
    Answered - Pending Review
    20 5
    Answered - Pending Review 20 views 5 comments Most recent by Raven Clarke
  • What is the best way to show an extension has occurred to the original due date and track changes?
    In Using Smartsheet
    I created a smartsheet to track the requests my organization receives. A response must be provided to each request by a certain date (due date). However, occasionally this due date must be extended. I would like the smartsheet to show: The…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Andrée Starå
  • Is automated workflow supposed to be slow?
    In Using Smartsheet
    Hi, I've recently been using Smartsheet and discovered the Automated Workflow feature. At first glance I thought it didn't work but after saving and thinking for 30 seconds, the sheet updated. My sheet is almost empty, I only made one to t…
    Accepted
    13 3
    Accepted Answer 13 views 3 comments Most recent by Andrée Starå
  • Parent row not included with Alerts/Notification
    In Using Smartsheet
    Hi Team, While that I have setup a Alert/Notification Automation, I see that the parent row is not included. How do I make sure that parent row is included so that the owner/Assigned to person has reference to what Task this relates to. Le…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå
  • Automation alerts when the email's owner is deleted of the company's system
    In Using Smartsheet
    I'm wondering what would happen to the automation alert if the owner of the sheet is deleted of the company's system. I know I can change the ownership before that, but if I forgot tot do that, what would happened to the automation alert ?…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå