-
Input Mask - incl. Webforms
Little surprised I've not found a similar post about this, unless I'm using the wrong terminology. Is there a way to enforce a specific input mask - say I wanted to caputre phone numbers - I want them to appear as +44 000x-0000000x (where 0 is expected numeric and x is optional numeric) - standard database/data integrity…
-
10 files per web form submission
Hi We are using the webform funtion to collect documentation from our contractors and 2 things are hindering this process: 1. you can only upload one file at a time, instead of being able to click 'upload' and then select multiple files, and 2. there is a limit of 10 files per webform Does anyone have tips, or a way around…
-
Webforms | Survey - Customizing Column Headers or Question Content
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…
-
Requiring comments based on Web Forms Answers
Was trying to use web forms for a basis of a survey. Ideally I would like to create a required comment field based on the answer of the drop down box. Is this possible?
-
I just Cant Seem to figure this one out help please.
Ok In the picture Below Cell ?:? is going to be a drop Down List pulled from a drop down list on a web site. Action wanted : * After I figure out how to link the Drop Down List in F20. * I would like to create a new Row above row 26 and Insert the Drop Down List Slection into B25 instead of in F20. * * Cells…
-
How to define a default value for a field with a formula
Hello Guys, I am using the webform feature to create the new record for my sheet. In each record, I have cells called Created Date, Closed Date and Duration. And the Duration is equal to a formula which count the gap between Created Date and Closed Date. f(x)=NETDAYS([Created Date]1,[Closed Date]1) The formular is working…
-
Customize a Form
Hi, Does anyone know how to customize a form? Or are we stuck with the basic layout that shows up. We have several forms that clients fill out when they want to request a new report, report changes, Troubleshooting. I have created 3 smartsheets, 1 for each- and would like to have the forms match or be close to what they…
-
Drop down box on a webform
Hi there I have created a dropdown box on a webform on smartsheet. Firstly, does anyone know how to edit the drop down list once created? Secondly, I have noticed that completed answers on the webform are not feeding back to a master sheet if the answers were in a dropdown list. Any suggestions would be much appreciated.…
-
Webform link is asking for log in
Hello, Is there anyway to bypass the log in on a webform? I've used the link to embed on our website but anytime anyone clicks on it, it takes them to a log in page. This is not only confusing but it is also detering people from filling out the webform. Any suggestions?
-
Cell value if there is an attachment?
I would like to add a cell that will show certain text if there is an attachment to each row, is this possible?