Forms

Discussion List

  • Word Count Limitations?
    In Using Smartsheet
    I am setting up a form but need to limit the word count. I already built a formula in the sheets with formatting to identify when an entry has surpassed the 1,500 word count max but I want to limit it while someone is filling out the form…
    Accepted
    26 2
    Answered ✓ 26 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • How can I change dropdown values from text to number in forms
    In Using Smartsheet
    I have dropdown values as numbers like below However when the form is submitted, they look like text When i manually change them from gridview, they are in number format
    Accepted
    32 3
    Answered ✓ 32 views 3 comments Most recent by ataberk_teknekaya Using Smartsheet
  • Approval Workflow and SUMIF Formula
    In Formulas and Functions
    Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. T…
    Accepted
    14 4
    Answered ✓ 14 views 4 comments Most recent by danielleelalouf Formulas and Functions
  • How to Auto-populate form with Request Number
    In Using Smartsheet
    Hello, I am creating a form for customer's to input data into our sheet. This form currently asks for "FER Number" which the customer is currently requested to input. However, I'd like to make this "FER Number" auto-g…
    Accepted
    224 11
    Answered ✓ 224 views 11 comments Most recent by KathyL Using Smartsheet
  • Can I have 2 users fill out the same form?
    In Using Smartsheet
    Hello, Is it possible to have user #1 fill out the required fields of a form and submit it, and then have user #2 view the same form with the answers submitted by user #1, and fill in any optional fields? I am looking to streamline a proce…
    Answered - Pending Review
    24 7
    Answered - Pending Review 24 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Announcement

    Yay! Text formatting in Smartsheet forms
    In Using Smartsheet
    Smartsheet forms now have the ability to format text in the form title, form description, and field help text. Check it out and let us know what you think. Style (Bold, Italic, Underline) Text color & highlight color Bullets & num…
    570 25
    Announcement 570 views 25 comments Most recent by mdcatlett Using Smartsheet
  • Add Comment Section to a form
    In Using Smartsheet
    Hello, Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section? Thanks! Matt L.
    Accepted
    1011 10
    Answered ✓ 1K views 10 comments Most recent by Eliz Using Smartsheet
  • Locking some users from editing a form
    In Using Smartsheet
    Is it possible to prevent someone from editing a form after they fill it out? I want certain users to not be able to change their form responses after submission. Thank you, Maya
    Answered - Pending Review
    22 2
    Answered - Pending Review 22 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Way to automate check boxes in a form?
    In Using Smartsheet
    Hello, I have a form with multiple check boxes for people to check off based on which option they want (they can select multiple or just one). I want to be able to have an ALL OF THE ABOVE option but want to find a way so that when a user…
    Accepted
    30 3
    Answered ✓ 30 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • STOCK FOLLOW UP/ FORMULA/LINKED SHEET
    In Formulas and Functions
    Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form an…
    Accepted
    23 4
    Answered ✓ 23 views 4 comments Most recent by TomorrowlandSup Formulas and Functions