Using Smartsheet

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

Discussion List

  • IFERROR not working
    In Using Smartsheet
    I've created an intake column to count the # of days based on a date in the Approval Request Submitted column. I want to use IFERROR to remove the INVALID DATA error and replace it with a "0" (zero). my attempts were; =IFERROR(…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Andrée Starå
  • Blank Destination Sheet when trying to build Copy Rows WF
    In Using Smartsheet
    Hello Smartsheet gurus, I am attempting to build out a workflow that automatically copies rows over from a source sheet I have Admin access to, to a destination sheet. My problem is, every time I try to select a destination sheet, the sele…
    Accepted
    9 3
    Accepted Answer 9 views 3 comments Most recent by Maram Mohamed
  • Power Automate Smartsheet
    In Using Smartsheet
    Hi, I am trying to insert a new row based on a trigger that when a new row is created to a sheet. I have used Zapier a lot in past to setup these tasks but Power Automate is way to complicated. I am unable to map column name from trigge…
    67 4
    67 views 4 comments Most recent by Samuel Mueller
  • How to get Row ID or Original ID in Smartsheet
    In Using Smartsheet
    I need this for an integration with Zapier. Can anyone tell me how to get this number for all rows in a sheet?  Note - Row ID is not Row Number. It should look like this: 5418114689066884 Thank you!
    3079 11
    3.1K views 11 comments Most recent by Samuel Mueller
  • Multi checkbox with logic to dropdown fields
    In Using Smartsheet
    I'm creating a form for job recruitment. What I'd like to be able to do is have a multi-select checkbox with logic that only opens an additional field for the checked items (pic below). I set up a Logic for each individual field, but when …
    Accepted
    19 3
    Accepted Answer 19 views 3 comments Most recent by CourtneyGMPC
  • User Permissions
    In Using Smartsheet
    Hi I have set up a Workspace called TDR under which I have the PMO template. We have numerous Project Managers and I want to allow them to create new Project Level, project folders, from the Template folder. What access do I need to give…
    CJU Profile Photo CJU
    Answered - Pending Review
    7 6
    Answered - Pending Review 7 views 6 comments Most recent by CJU
  • Need way to add a counter on a dashboard for user "views" or visits
    In Using Smartsheet
    Hi everyone. Absolute beginner here. I'm tasked to make a few dashboards for other internal company teams on project progress, etc. We want to track how often people visit each dashboard and thought it might be useful to include that as a …
    241 6
    241 views 6 comments Most recent by Kristine Gagne, CSM, CSSGB
  • Is there a way to show the history of a cell in another column on the corresponding row?
    In Using Smartsheet
    I have a due date column on my smartsheet, but would also like a column that shows the cell history of that due date so it is visible on the sheet without having to click on cell history each time. Is there a way to automatically populate …
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå
  • How to view and use the Modified and Created fields in Smartsheet
    In Using Smartsheet
    Is there a way to capture the Modified By and Created fields in a sheet or report? I'd like to be able to create filters based on the current user in a sheet. Situation: Multiple users giving input on one Sheet. Issue: Concerns with dat…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Rick Girard
  • Availability Views
    In Using Smartsheet
    I would like to show team members availability - *available days *vacation days *sickdays for complete year ,, Is there any template to achieve this or can anyone please help me how to proceed with this. For Example: Something like this
    PYI Profile Photo PYI
    Answered - Pending Review
    19 1
    Answered - Pending Review 19 views 1 comment Most recent by Andrew Stills