-
Pre-Populate Form with Entire Field from Sheet
Hello Community, I am trying to figure out how to pre-populate a form with a multi-word field. I know how to populate the form with a field and can provide part of my formula below, but it only brings in the first word of the field and not the entire thing. Can someone please let me know how to bring in the entire field?…
-
INDEX(MATCH formula issue
I am trying to use helper columns to consolidate form submissions onto the top row of a sheet, in order to use Document Builder to populate a PDF with the inputs from eight different sessions. There are about 10 columns per session. In the screenshot below, the "Which Session" column is a drop-down list with radio buttons…
-
Can I add a table to a form
In a form, I have a text field that a user can fill in with product information. What I was hoping to do within that one field was to have a table, so users can format the information in that response correctly? Please see attached image - what I want to appear is in red. If this is not possible is there a different way to…
-
Multiple workflows in a worksheet - "This workflow was triggered by at least 5 other workflows"
Hello all, I'm currently having a sheet with the answers from one survey form (30 questions). The answers are YES/NO option, but then I would need to convert the YES and NO in 1 and 0. What I did (and maybe I overcomplicated myself) was to create 1 workflow per column. When a new row is created then this triggers the 1st…
-
Forms: How to print/generate a PDF with field label and answers
I am creating a survey form, and the questions are quite long. There is a character limit for the column/field name, so I just use numbers (e.g. "question 1", "question 2") in the column/field name and put the actual questions in the field label. That seems to work for the form. However, I want to be able to print/generate…
-
How can I get form submitter name or even better person from users directory?
Hi everybody, I'm trying to do something very similar which is shown on the animated gif on the Smartsheet home page. Table of requests where you can see the request title and also the requestor, which is in the animated gif represented as full person name with small icon. The animated sequence is then also showing the…
-
Prevent Logic from Disappearing when copying a Form
I am trying to create a template for a form that my team will be using going forward. I've created a template and have all my fields set but when i save as new or build off the template all of the logic as well as required fields and Multi Line fields just go away. the Fields are still there but I have to go in and update…
-
Multiple approvals process
I'm creating tracking for a change process through various departments. What I need after project submission into Smartsheet is: Team 1 - intake, review, notes and approval (either approved - no comments, approved with comments, or hold - with comments) Teams 2-15 - same as above No one team's approval is subject to any…
-
Nested Form Logic?
Good Afternoon Smartsheet Pros! I am trying to create a form that adds new employee data to a spreadsheet. My desire is that I have functionality that allows the form filler to add multiple personel entries to the same form. My instinct was to create an 'Add Additional Employee' checkbox with logic that populates the data…
-
Calculate a date in a form
I have two fields in a form: Request Type and Due Date I need to calculate (or perform a vlookup to another sheet) if the date that is chosen dfalls within an agreed timeframe based on the Request Type that is chosen. i.e. if Request Type = Email AND Due Date is less than 5 days from the submisson date then show a SLA…
