-
Using Smartsheet Forms as multi lingual survey tool
Hi, I am using the forms function to collect data from people in many different countries. The information we are collecting is in binary, single select, and multi select formats. This information is being summarized in a separate sheet, where we are counting the instances of each response from the binary, single, and…
-
Can I populate multiple lines in a report from one form
I am trying to automate our joint health and safety checklist. I have created my data sheet with 88 columns and created my form. Each question has a drop down with yes, no or N/A. When no is selected a comment box comes up to insert the issue. What I want to do in my report is create one row for each issue that arises…
-
Http:// links are "filtered" out of form
Hello, I have a form where I've placed a link in the main header of a form simply by using the standard Http:// link format. While this links works as a link when viewing the form, no other descriptions or headers will display the link as clickable. Am I missing something? Let's say they links in the main header worked…
-
Is there a way to add text and signature after it has been submitted and signed?
My team is developing a process for risk acceptance between departments and IT. We have a preliminary process that currently lives in a Word document and we wanted to see if it can be put into a more automated process in Smartsheets. There are 2 parts to the document that each require signatures/sign offs. The process is…
-
Separate form submissions from reference data
I've imported a CSV File into Smartsheet that serves as my database repository for Form Fields. My Form is created on this sheet in order to reference data values within the grid for multi-select form responses, which are limited to the values provided. I would like for form submissions to land on a separate sheet as my…
-
Need a formula to have all work-flowed moved cells to go to the top of the sheet
Every time I put an automation to move cells to another sheet, they end up at the bottom of the new sheet. Is there a formula I can use so that they can start coming in at the top? Thank you!
-
Can a report automatically update (add rows) as the sheet behind the scenes is constantly adding cel
Can a report automatically update and add the rows that the sheet it is being used on? My sheet is constantly being added to and I would like the report to also add the cells when the cells are added in the sheet.
-
Form text color defaulting to white?
Hello! We just noticed on our creative request form that the text is defaulting to white and we're unable to change it to black using the formatting options. Any help would be greatly appreciated! Thank you!
-
Create a backlog item when status changes in a form?
I created an intake request form and it has a status field that on submission is set to Submitted as default. A email is triggered to the team that a new intake was submitted. The process then requires someone on the team to review it and set up a discovery session. Is it possible when the status changes from Submitted to…
-
Why is one sheet workflow bringing the cells to the top and 1 sheet is bringing the cells bottom
I have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.
