-
Auto-populate a form field with the result of a formula in the sheet.
I have my sheet set up so that when I click the generated URL, certain fields of the form that the URL leads to are auto-populated with values from the same row. My issue is that it seems like I can only auto-populate manually entered values and not values generated from column formulas. Is there a way to do this? Maybe I…
-
Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
-
Bringing a Finance Exam online
Hi, I have been facilitating virtual finance exams for a bit but because we currently email them to the participants, it's becoming hard since they get to keep a copy of the questions. (We don't tend to change them) Is there a way I could use Smartsheet for this purpose? I'm worried that the forms function allows them to…
-
CAPTCHA is reuqested, but form setting does not require it
In a form we are using the setting for CAPTCHA is switched OFF. But still some users report that CAPTCHA is requested before they can submit the form. Does anybody experience similar problems and knows a fix for this? Kind regards, Carsten
-
Disregarding N/A in Formula
Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary…
-
Conditional formatting or restriction in format for forms
Context: Employees have to enter data and use a unique identifier which has a naming convention. I would like to either use conditional formating or restriction of a certain format for Smartsheet Form in order to minimize the data cleaning effort. Are there any workarounds?
-
Cannot open attachment in confirmation email
Hi, After fill in the form and upload a file, and check "Send me a copy of my responses" I received a confirmation email as below But when I click on the File attachment, it did not open the file. It seems that is just a text. How to open the file attachment? Can you help?
-
Attachments in Forms
Hi Everyone, We have a form which will be filled by the customers. There is a attachment field added to the form. Now, we want two types of attachments to be done - 1. Invoice copy & 2. Images of the issue. Invoice copy should be mandatory, images are optional. Is there a way to do that in forms? We can either make the…
-
Ongoing Performance Evaluation Setup Dashboard - Form Won't Populate
Hi - I was asked to set up this dashboard: The template has been downloaded and the new workspace has been created. The form is set up, and when I did a test fill out of the form, the data went to the "Feedback: Positive" report, (which populated onto the feedback portion of the dashboard) but the data won't populate to…
