Using Smartsheet

Want to know more about using forms? Interested in better understanding automation? Want to see what's possible with dashboards? Post your question or discussion to Using Smartsheet.

Discussion List

  • New Forms Enhancements - Symbol images and unrestricted dropdown
    In Using Smartsheet
    Hi Community, I’m pleased to tell you about two enhancements we just released for web forms and the form builder. First, it is now possible for web form respondents to select list values and/or enter their own values in the same contact …
    353 2
    Announcement 353 views 2 comments Most recent by Andrée Starå
  • Formula to Check Duplicates on a Multi-Select Drop Down
    In Using Smartsheet
    To evaluate each value within a multi-value cell is what has me stumped. 'CountIf' exceeding 1 is the key for single values. I thought about using 'contains'. I'm curious if anyone has figured this out.
    Answered - Pending Review
    4 1
    Answered - Pending Review 4 views 1 comment Most recent by Jackie Ziemke
  • Restrict date field to only specific day of the week
    In Using Smartsheet
    I have a date field in my smartsheet that I need users to select a specific date, but I would like to restrict them to only be able to select Fridays. Is there any way to do that on the form? I do not want to have to prepopulate a drop…
    3 0
    Question 3 views 0 comments Started by Adam Qualls
  • Roll up not working as expected
    In Using Smartsheet
    I have a project with several tasks that are children of a parent task. The roll-up of the Work and Duration fields of the parent item are not working as expected. For some parent tasks, the roll-up seems fine, but I have other parents who…
    2 0
    Question 2 views 0 comments Started by Michael Sisco
  • Inbound cell link loses timestamp info and only shows date
    In Using Smartsheet
    Hello! I am trying to capture times clocked in and out by a team. I created 2 input sheets, one that captures time in via a system timestamp of last modified, and another to capture the timestamp for when one clocks out. I am then pulli…
    10 0
    Question 10 views 0 comments Started by Archita Dasgupta
  • Image in a Webform
    In Using Smartsheet
    Hi, Is there a way to feature an image in a webform? We are looking to have people select which image they prefer. Thanks Community!
    5 0
    Question 5 views 0 comments Started by lisa.bolger27646
  • how to make decimals work?
    In Using Smartsheet
    Hi i´m having a #UNPEARSABLE error everytime y tried to use decimals in my formula, for example: =IF([KPI ASIGNACIÓN DE OBRA]4 > 3; ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01) how can i multply with decimals? Thanks
    Answered - Pending Review
    3 3
    Answered - Pending Review 3 views 3 comments Most recent by John Jonassen
  • Copy and paste a row of information from smartsheets to an email
    In Using Smartsheet
    is there a way to copy a row of information and paste it in an email to send to someone rather than having to retype the information in the email? Smartsheet doesn't seem to want to play along lol. for instance Example I cant copy and …
    Answered - Pending Review
    7 3
    Answered - Pending Review 7 views 3 comments Most recent by David Tutwiler
  • How can I send a reoccurring email with an embedded link to a survey form?
    In Using Smartsheet
    Hello All, We currently have a survey form that we send twice a week to our team of 20 plus employees. We also have a helper sheet that uses formulas to gather this information into the statistics we want to share. We currently do this…
    Answered - Pending Review
    14 3
    Answered - Pending Review 14 views 3 comments Most recent by David Tutwiler
  • Basic automation not working right?
    In Using Smartsheet
    I thought I set up a very simple automation but it doesn't work even after trying variations. I just want to send an alert when an entry in one cell changes. I set up a column using Yes and No options (default is blank) so that when some…
    156 6
    Accepted Answer 156 views 6 comments Most recent by Denise Heffron
  • Report access without base sheet level access
    In Using Smartsheet
    Hi, I have a user that needs access to a report (which filters the data based on a parameter and only returns certain rows). However it doesn't seem like they can view it unless: I make the report public, which isn't an option as it conta…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by sschreiner