-
How can I change dropdown values from text to number in forms
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
-
Approval Workflow and SUMIF Formula
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. The request entry is copied to a separate sheet that has a calendar of each event along…
-
How to Auto-populate form with Request Number
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-generated/auto-populated. I'd like the form to reference the last input "FER Number" on Smartsheet (bottom…
-
Can I have 2 users fill out the same form?
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 process so that it creates one entry in my sheet, rather than have each user fill out the…
-
Locking some users from editing a form
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
-
Way to automate check boxes in a form?
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 of the form checks ALL OF THE ABOVE, it will automatically generate all the other…
-
STOCK FOLLOW UP/ FORMULA/LINKED SHEET
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 and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
How to collect a form user's name anonymously?
Hi all. I want to send a survey form using Smartsheet to a group of users. I want to be able to collect the user's name on the backend (if possible) without the user knowing I'm collecting their name. It's basically so the user will be truthful in their survey responses AND only I would know who said what. Is there a way…
-
Smartsheet Form fields and emails
Is there a way to only show fields that have content in an email/approve or deny email. I have several forms that have logic built in and have fields that are not viewable on the form but all fields show in the emails. I seem to remember this is an option, just do not remember how to get there.
-
Using Smartsheet for Event Registration Acceptance and/or Event Registration Reporting
1) Are you using Smartsheet to collect registrations for your events? 2) Are you using Smartsheet to report on event registrations in a shared report or dashboard? 3) Can we collaborate? We are an association membership community with a limited budget. We are thinking of using Smartsheet for several different use cases: A…
