Discussion List

  • Auto fill a second column based on a drop down selection using a form
    In Formulas and Functions
    I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.  Situation: I would like to have a form where someone selects one op…
    7605 22
    7.6K views 22 comments Most recent by Genevieve P. Formulas and Functions
  • Allow user to edit content from a form
    In Using Smartsheet
    Each week, we have a status form that our user base enters. When they click submit, an email with a copy of their submission is sent to them. Is there a way to add a link to that email so they can EDIT the form they submitted? (Google fo…
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • How to include a customer satisfaction feedback after a form is submitted?
    In Using Smartsheet
    We have developed a form recently for our Business scenario and we would like to add in a feature. I am not sure if it is existing as of now in Smartsheets. We need to send the user who submitted the form to fill an Satisfaction from scale…
    Answered - Pending Review
    21 2
    Answered - Pending Review 21 views 2 comments Most recent by Abhijith Using Smartsheet
  • Conditional quantities for pricing sheet?
    In Formulas and Functions
    Smarties, I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2…
    32 4
    Accepted Answer 32 views 4 comments Most recent by BrianT Formulas and Functions
  • Formula Interferes with Form Data
    In Formulas and Functions
    I have a sheet where the first row is full of SUM(row2:row40) functions. This sheet has a Form that submits new data and I want the new data to be included in the totals at the top. I only have 10 rows filled so far, so I expected a form s…
    11 3
    Accepted Answer 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Forms Customization
    In Using Smartsheet
    Hello, It is possible to customize forms? Like put background images or simple change font color. My main objective is to put an image of an enterprise in form to make him more professional or with a specific customization. Thank you.
    Answered - Pending Review
    2 3
    Answered - Pending Review 2 views 3 comments Most recent by Angie S Using Smartsheet
  • No Email Valiation option for Multiselect contact
    In Using Smartsheet
    Hello Team . I would like apply the newly released feature of validation in forms for email. I have requirement that i should allow multiple task owners but when I check in form for multi select contact email validation option is not avai…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Krissia B Using Smartsheet
  • Customizing Form - No Logo & Form Title in Side-by-Side Format
    In Using Smartsheet
    We like being able to customize the appearance of our forms using a background and logo. When I switch from a "Vertical" form to a "Side-by-Side," we lose our logo and the form title. Screenshots attached. Am I missi…
    22 6
    Accepted Answer 22 views 6 comments Most recent by alwayslearning Using Smartsheet
  • Update Columns in Existing Row Using Forms
    In Using Smartsheet
    Hello, I have a sheet where I am tracking construction progress.  There are a lot of data/calculations that my field personnel do not need.  I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.)  Each…
    1264 9
    1.3K views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Required AND Hidden Fields in a Form
    In Using Smartsheet
    I am using a URL parameter with a form to populate a hidden field. that field should always have a value. However, if the URL parameter is missing, the form can still be populated. It would be great to allow a field to be both hidden an…
    23 2
    23 views 2 comments Most recent by Mark Salamon Using Smartsheet