Forms

 

Discussion List

  • Formula Help
    In Formulas and Functions
    Hello, I'm trying to create an inventory of all the items we currently have in our uniform room. The first column will have POLO Shirts USED through the year, the second column I would like to have our current stock inventory inside the …
    Unresolved
    68 1
    Question 68 views 1 comment Most recent by Alan P. Formulas and Functions
  • Disregarding N/A in Formula
    In Formulas and Functions
    Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Sum…
    Answered - Pending Review
    24 6
    Answered - Pending Review 24 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • FORM Dropdown lists with filtering capability
    In Using Smartsheet
    Hello! I hope you can help me with this, since i don't know either if it is something that would be possible to achieve in Smartsheet, in the first place. I am trying to create a form with dropdown lists that should work this way: The foll…
    Answered - Pending Review
    15 4
    Answered - Pending Review 15 views 4 comments Most recent by FedericoS Using Smartsheet
  • Conditional formatting or restriction in format for forms
    In Using Smartsheet
    Context: Employees have to enter data and use a unique identifier which has a naming convention. I would like to either use conditional formating or restriction of a certain format for Smartsheet Form in order to minimize the data cleaning…
    LJK Profile Photo LJK
    Answered - Pending Review
    16 5
    Answered - Pending Review 16 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Cannot open attachment in confirmation email
    In Using Smartsheet
    Hi, After fill in the form and upload a file, and check "Send me a copy of my responses" I received a confirmation email as below But when I click on the File attachment, it did not open the file. It seems that is just a text. Ho…
    Accepted
    16 1
    Answered ✓ 16 views 1 comment Most recent by Gia Thinh Using Smartsheet
  • Attachments in Forms
    In Using Smartsheet
    Hi Everyone, We have a form which will be filled by the customers. There is a attachment field added to the form. Now, we want two types of attachments to be done - 1. Invoice copy & 2. Images of the issue. Invoice copy should be man…
    Accepted
    59 2
    Answered ✓ 59 views 2 comments Most recent by Jake Gustafson Using Smartsheet
  • 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
    13 1
    Answered - Pending Review 13 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
    16 5
    Answered ✓ 16 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