-
Interactive Forms
I would like to create a form to collect a variety of information from users. For example, we want to record publications, presentations, and proposals that a faculty member has done in the past month. However, I'd like to keep the form short. If a faculty member has had 2 publications, but 0 presentations and 0 proposals,…
-
File links uploaded into Google form are garbled in Smartsheet
I have an existing Google form and one of the options is to attach files. When the form is submitted, the values I'm getting in Smartsheet are garbled, something like: "0B6fDccPdKcYeY0tlcjJnVTlMYWM,0B6fDccPdKcYeQi1Malg1YXVDMmM,0B6fDccPdKcYeZkIxVURBU3hjbWc" This column is supposed to be populated with Google Drive links.…
-
How to setup a quotation number request feature?
I would like to set up a form where the users will enter the details of a given, and submit. An automatic sequential number is to be assigned to this entry and notified to the user who sent the request using the form. Is that something that can be done with smartsheet?
-
Form link
Hi - I have a form created, and want to embed the link on our corporate website. I would like to know what will cause the link address to change, ie. does changing/editing the form cause the link to change? (and then I would need to get the webmaster to update the link). Thanks, Olli M.
-
How to Create a Purchase Order
Hi, I am trying to create a purchase order form from data stored in an Order intake form sheet. I need to be able to take certain fields from the intake form sheet one line at a time and create a standard looking Purchase Order in PDF that I can send for execution via DocuSign. Thanks! Alex
-
Tracking purchases
Trying to assist my purchasing department... I've set up a sheet for a department to enter their purchases, but my issue is that our purchasing dept wants to have it itemized. For example, I might have an Amazon order for $1000.00, but that $1000 is comprised of 1 printer that's $500 and a computer that's $500. I'd like to…
-
Send email to people who fill out form at a later time
In trying to use Smart Sheet as a way to track applicants, and even use a form as an application, I'd like to be able to notify applicants that did NOT get the job that they didn't get the job. Is this even possible if I collect email addresses?
-
Locking columns but allowing form submissions, comments and attachments
Hi, I have a sheet I'd like to share with others, but not have them be able to directly edit the info in the columns. Instead, I'd like them to use the comments as well as use a form to submit requests. The form fields would correspond to the columns in the sheet and their submissions would appear at the bottom of the…
-
Use Smartsheet row data to populate a Template
I am looking for a way to automate a process to take data from a single row in Smartsheet and populate a template. Working in the construction industry, processes are slow to change and we still need to PDF documents for communication with our customers (RFI's, Change Orders, etc). I have setup the forms and procedures for…
-
How Do I Prevent Spam Entries On My Web Form?
I see no option for Captcha or Honeypot to prevent SPAM bots from attacking my form, which is currently being bombarded by fake Chinese entries. How do I implement this?
