-
Conditional logic in a form
I have created a form with conditional logic. The logic displays "catalog responsible" (column was previously set as contact list) and it is displayed only if the previous field is selected with "prod" option (column is set as dropdown) The form works perfectly, but since other group of persons will have access to the data…
-
Form response adding up to exactly 100%
Hi there, I am creating a form to track employee time against projects. I have created individual drop down lists (10%, 20%, 30%, up to 100%) for each project. I want an error code to pop up if employees responses add up to more or less than 100%. Is this possible? I believe Rick had a similar question here-…
-
Smartsheet App Barcode Scanner
Anyone out there find the barcode scanner on the app, particularly into webforms SUPER sensitive!? We've just started using a product expiry system in smartsheet which requires those receiving orders to scan the product barcode into a webform and enter the expiry date, qty etc. Then once that goes through to a 'landing…
-
Printing a form
Hi there, Is it possible to print a blank form? We have a couple of forms that are particularly long and require some research to complete. We would like to be able to provide a PDF of the form, both before and after completion. Many thanks V
-
Access/Restriction using forms
Hello, I created a dashboard with the intent of approved access only users for some links with the widgets. It is functioning for the links to pages, but not the forms themselves. Everyone can view, but i want to limit access to some forms. Though the my links, everyone can submit a form. Can someone please tell me how to…
-
Automatic Deletion
I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the data. They propose that a notification is received when someone fills out a form and the…
-
Forms : URL Query String with Multi Select Dropdown
Is there a way to use URL query string to pre-populate a dropdown multi select with more than one value in a form?
-
Can we merge two form inputs into single row?
I have a sheet of 10 columns. I have created a form out of it. First 5 needs to be filled by one person initially. However, remaining 5 fields needs to be filled by other persons (multiple persons) at same time and also at other times in some cases. How should I fix this? What is the best solution for this?
-
BUG - Smartsheet Form - Default Value Store
CONTEXT: I have a long form with single-select fields. I am trying to set all the default options. BUG: When I save + open the webform the default options do show but they don't actually save in the form editor UI (see markups on screenshot below) and also if I make any other change and save the form all the default values…
-
Worksheet population with Formulas
I have a spreadsheet populated by a form where one field needs to be populated using a JOIN of multiple fields from the spreadsheet which are populated using from entry and another needs to be populated by a VLOOKUP. I've tried assigning the formulas to the blank rows ahead of time and using the Change Cell Value workflow…
