-
Unique codes
Hey all, I am trying to create a system that will check a unique code that is entered through a form and display if this code has been used already or not. I have a formula in the summary sheet that will asses if the code has been used or not: =VLOOKUP($Code$1, {Z Codes Trial Database Range 1}, 3, 0) The problem is that I…
-
I'm the owner of a number of sheets and used to be able to email forms, but can no longer do so.
I have been able to create a number of forms and I used to be able to send email notifications to people to complete them. However, I can no longer seem to send the emails although I can share a link. We are on a business subscription and I'm the owner of these sheets.
-
Line Breaks in Text Fields on Forms
We would like to be able to use line breaks in the text fields of forms. For example, if you are typing data into a form linked to a smartsheet, it would be helpful to have the capability to skip lines or "enter" to the next line to continue inputting information. This would be helpful in both data organization and…
-
Use form to populate an existing row?
I have a sheet that is being used to track data and requires comments from other people. Is it possible to use Form to collect these comments and have them populate into designated rows on the sheet (instead of creating new rows with each new response)?
-
Export input into a formatted form
Our current package lacks the dynamic and data shuffle features, and unfortunately, we're unable to invest in acquiring them at the moment. With that in mind, could you please advise on the most effective method to transform a submission input from a form into a visually appealing PDF for printing?
-
Forms: Best practice to reduce columns when using forms with logic
I am setting up an IT ticketing system to replace our aging system. I have a ticketing form set up using logic. In short its --> Issue or Request --> Request type select --> Subtype1 --> Subtype 2 --? etc... --> Issue type select etc... all the way down... As the user makes selections, more options are presented. The…
-
Merged: Forms: Advanced logic to reduce number of columns
This discussion has been merged.
-
Can you automatically rename/add prefix to a mapped document?
I'm having an issue where I'm regularly automating a mapped document. The input comes in via a form, the service rep makes sure all content is ok, then hits the "create PDF" checkbox. A PDF is created and attaches itself to the row. This is great, and gets around the fact you can't just print a nice looking version of the…
-
Clean Form Drop Downs
It would be amazing if the forms visual could be updated so when you select Horizontal Buttons, it evenly spaces out the options instead of looking something like the image below. It is very difficult to read.
-
Automatically Creating Dashboards from Form Submissions: Is it Possible?
Hello Smartsheet Community, I'm currently leveraging forms to collect QBR feedback from each of our change managers. Each form submission results in a new row of data within my sheet. I have a vision to create individual dashboards based on the data from each of these rows. Essentially, every time a form is populated, I'd…
