-
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…
-
Leveraging forms for satisfaction surveys
Dear community, I aim to capture feedback from stakeholders on specific projects (triggered by a % completion and /or a duration). My survey needs to allow: To display a couple informative fields (as captured in my main grid) – without an option to edit these To capture 3 pieces of information (one of them being free text…
-
Forms error on submitting a google sheet document
I created a workflow that requires submitters to fill out a form by attaching a document. This form is accessed via a google site which won't let me add a downloadable excel file. As such this needs to be in google sheet form, but I receive the error below when trying to submit.
