-
Report with the last entry to each person's forms
Hi! I need to know how I can make a report with last entry to each "assigned to" with the row that generated into the Form. Anybody know how do it?
-
Form Email to only show what was filled out
Lets say I have a form that has 200 questions on it. The person who is filling it out, only answers 50 of those questions and attaches some documents. The email alert that I get automatically shows me all 200 fields and i have to scroll to see which ones they answered vs they didnt. How can I make the email only send what…
-
Looking for a way to auto fill the Label and Description on a form
Is there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a voting ballot for prioritizing issues. The primary key is the Issue number then there is a…
-
Smartsheet Forms - Displaying View Only Fields
We have a SS Form that we are using to collect Project Go-Live Confidence for that month. The Form provides the PM with the Project Mgr Name, Project Name and Current Go-Live Date along with conditional questions. We want some of those fields to be View Only on the Form (PM, Project Nm and Curr Go-Live Date). I haven't…
-
Workflows and Conditions
Hello, I have a data collection sheet that stores a variety of sites data. I will do my best to explain the setup, as well as desired outcome. This sheet contains two forms, (1) a data collection form used for new sites [requires 3 Point of Contact (POC) emails, site name, and various other fields that will not be…
-
dot and comma to separate dollar and cents
Some colleagues in US or other countries all over the world capture data via a form into Smartsheet. Sometimes cents are neeeded so the dot will be used to separate the dollar from the cent. My account is in Germany and the the Germans use the comma for separation not the dot. All data run into a failure and I have to…
-
Can I use a form to edit information of a register?
Hello to all of you! I'm brand new using Smartsheet and I could use a hand. Hopefully I'm not crossposting. :) We have a sheet with various fields. Sometimes we have meetings and we take a look of the values of one row at a time. That is sometimes exhausting because we ae moving back and forward, left to right to see each…
-
Is it possible to have a Start/End date on the same line?
I was created a request form for the office and I have to put a Start/End date option for this request. Would it be possible to have those options on the field line instead of different fields?
-
Issues with Form
Hello, I am having issues with my form: - When User fills out a form, they have to choose a department number from a dropdown. After the filled out form is uploaded into the sheet, the department number is changed? Example: User selects 577 in the form, but in the sheet it shows as 577.0 Here are some screenshots: The…
-
Form updates
I have build forms that have incorporated labels and helper text. I need a way that will allow me to resend the form with the labels and helper text and the previous answers in order to get updated information without requiring the user to refill out the entire questionnaire. The update request only sends the column…