Using Smartsheet

Archives for April 2021

Discussion List

  • Forms - Going back to make changes
    In Using Smartsheet
    Hello, Is there a way to go back to the form and make edits? for example, one section of the form is for user A which he/she will complete their fields, save and exit out of it. User B comes in later to update section two. How can user B b…
    Answered - Pending Review
    4 1
    Answered - Pending Review 4 views 1 comment Most recent by James Keuning Using Smartsheet
  • How to Trigger Workflow
    In Using Smartsheet
    I have a sheet that contains a status field that could be one of the following values: Closed, Pending, Active, Failed I'd like to trigger a workflow for an update specifically when the Status changes from Active to Pending. Any ideas on h…
    Answered - Pending Review
    14 3
    Answered - Pending Review 14 views 3 comments Most recent by Mark Cronk Using Smartsheet
  • How to create a form that dynamically expands number of rows of data for a single question?
    In Using Smartsheet
    Hello, I am attempting to create a Smartsheet form that resembles an Excel design and want to understand the best process when creating this. Challenge: This particular form will be filled out by users to enter their expenses incurred for …
    Accepted
    25 1
    Accepted Answer 25 views 1 comment Most recent by James Keuning Using Smartsheet
  • Index Match Between 2 Sheets
    In Using Smartsheet
    I am trying to use Index Match between 2 sheets to pull a value and can't figure out how to get it to look at the other sheet as a reference. I have tried several variations from what I have found here but can't get bast error messages. I …
    Accepted
    65 14
    Accepted Answer 65 views 14 comments Most recent by Kelly Moore Using Smartsheet
  • Using Forms
    In Using Smartsheet
    Hello, does anyone know when you use forms as a quiz and have multiple choices with only one right answer how do you ensure that only one selection is allowed? Currently we used logic to identify which answer was the correct one but I…
    Accepted
    11 6
    Accepted Answer 11 views 6 comments Most recent by Genevieve P. Using Smartsheet
  • Is it possible to do a mass change of permissions in a workspace?
    In Using Smartsheet
    Hi all, I put together a workspace that has an entire office shared to it, later realizing I should of made people editors instead of Admins. Is there a way to change everyone all at once time or do I have to click through each person and…
    Answered - Pending Review
    1 1
    Answered - Pending Review 1 view 1 comment Most recent by Bassam Khalil Using Smartsheet
  • Using Reports on Dashboards - Current User
    In Using Smartsheet
    Hi there, I have a report that shows a timeline for each of our clients and it is filtered by Current User based on assigned tasks. I was working on building out some dashboards for our Account Managers and when I add the Report Widget to…
    Answered - Pending Review
    83 1
    Answered - Pending Review 83 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Parent Rows Not Summing % Complete of Children Rows
    In Using Smartsheet
    Hello, I have a Sheet that has multiple children rows below the Parent Row (and tabbed in) and the Parent row either only shows the % Complete of the row directly below it or does not show percentage complete of any of the children rows be…
    Accepted
    25 4
    Accepted Answer 25 views 4 comments Most recent by Michael Hutcheson Using Smartsheet
  • Getting Error on Formula - #INCORRECT ARGUMENT SET
    In Using Smartsheet
    I am getting an error on the formula I have entered saying #INCORRECT ARGUMENT SET =IF(AND([EHS COVID Approved]@row = "Yes", [ExComm Travel Approved?]@row = "Yes", "[email protected]")) Basically …
    Accepted
    24 4
    Accepted Answer 24 views 4 comments Most recent by Paul Newcome Using Smartsheet
  • Message in a bulk email
    In Using Smartsheet
    When a user get a single request the message shows as I have it in the workflow, see this example. But when it is a bulk request, so 7 or more rows going to the same email the message I have in the workflow does not appear or when you cli…
    Answered - Pending Review
    41 4
    Answered - Pending Review 41 views 4 comments Most recent by Kimberlee Maciel Using Smartsheet