Forms

Discussion List

  • Ongoing Performance Evaluation Setup Dashboard - Form Won't Populate
    In Using Smartsheet
    Hi - I was asked to set up this dashboard: The template has been downloaded and the new workspace has been created. The form is set up, and when I did a test fill out of the form, the data went to the "Feedback: Positive" report…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Is there a way to check a box in a sheet based on data and checkbox in another sheet?
    In Formulas and Functions
    In this scenario, Index Smartsheet automation is to happen based on data in the Licensing Smartsheet. More specifically - Check box in Ready To Start E. cell in Index Smartsheet when Licensing Smartsheet States To Be Filed (checkbox) is c…
    Accepted
    47 4
    Answered ✓ 47 views 4 comments Most recent by imtonydillard Formulas and Functions
  • Recurring form submission error
    In Using Smartsheet
    We continue to see this error on forms connected to a specific sheet, even with all inputs given, required or not: The information you entered is incomplete or invalid. Once the error has occurred on a form, it persists until "fixed&q…
    Accepted
    17 5
    Answered ✓ 17 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Out of Service Formula
    In Formulas and Functions
    Hi Community, I'm attempting to create a formula showing the OOS status of the most recent submission for each asset based on the Asset ID in form submissions. For example, below Asset ID FD-001201 would be considered out of service, howev…
    Accepted
    17 10
    Answered ✓ 17 views 10 comments Most recent by Bryan Letourneau Formulas and Functions
  • Auto populate data in Forms
    In Using Smartsheet
    I am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
    3433 16
    3.4K views 16 comments Most recent by IanM Using Smartsheet
  • How to use countif with digits that start with 0?
    In Formulas and Functions
    Hi guys good morning. I have a difficulty with a formula. In the HR area of ​​the company I work for, we use a form to register for vacancies offered throughout Brazil and in this form we request the CPF (Individual Taxpayer Registration…
    Answered - Pending Review
    152 11
    Answered - Pending Review 152 views 11 comments Most recent by Genevieve P. Formulas and Functions
  • Gain access to form
    In Using Smartsheet
    Having received notification from a form I did not fill out, is it possible to visit the form? There's an existing link for viewing the sheet, but I'm certain I do not need access to the sheet itself. I think it would be helpful to add an …
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Nahum Using Smartsheet
  • How do I ensure an email is sent out when a form is filled out and submitted?
    In Using Smartsheet
    I used to have my form notify certain people when a new form entry hit the sheet with a certain selection, but I've completely forgotten how I did it and now I can't make it work again. We get many form fills and I need to make sure someon…
    Accepted
    17 3
    Answered ✓ 17 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Trigger Issue
    In Using Smartsheet
    For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number o…
    Accepted
    38 3
    Answered ✓ 38 views 3 comments Most recent by MVP OPS Using Smartsheet
  • Send form to update multiple rows but form is individualised to each row
    In Using Smartsheet
    Hi! Many thanks in advance for considering my query. I have a smartsheet which I am trying to use to send the same form to multiple rows however the form has to be individualised to each row with a unique URL. I am not sure if there is …
    jlg Profile Photo jlg
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Andrée Starå Using Smartsheet