-
Using forms to add data to an existing row
Hello, I can see that a form will populate data into the next available row in Smartsheet. Can forms be used by other Team members to to gather and add info to pre-existing rows, governed by a specific date as an example? Regards, Richie
-
How can I update a row's information using a form?
I have a sheet that identifies each submission by a submission number. If I use that submission number as the "matcher" how can I update the other columns in that submission number row? I created a form but it only adds rows at the top. However, my coworkers will be using this and they won't have access to the sheet so I…
-
Is autofill possible in this scenario? and how
I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I would like the next column to autofill with 18000 for the expected participants. Is there a way to do this? Thanks
-
Using Automation/Workflow to copy multiple languages form responses into one sheet
Hi, I have two forms one in English and one in Spanish. They provide exactly the same responses, just in their respective language. The Spanish version still has the field headers in English while the labels are in Spanish. I have created an automation that filters for a particular school and creates a copy of the row on a…
-
Form columns update other form column
Dear reader, We have developed various forms (per service) to map the use of our services by our customers (Non Smartsheet User). The customer must enter his company name on every form, but this is not desirable if a customer submits all different forms at the same time. Is there a possibility to develop one form where the…
-
Employee Pulse Survey Template Set Formula Question
Hello I downloaded the template set for the employee pulse survey when I customized it, the formula to score the questions got erased. Does anyone have the the formula for the helper columns to assign a number next to the survey result? For example neutral should show 3 in the locked column. Thank you!
-
Workflow: Request Update Form
Hello, For the automated workflow - request update option, if I have this sent out to more than one person to complete and they both leverage the linked form from the automated Smartsheet email, how does Smartsheet intake that information? Would it create two entries or combine into one? This would be for a weekly status…
-
Creating a Non-Fillable Document
I use Smartsheet forms to map our customers' usage of our products, however I would like to develop a definition list because we work with international customers. The idea is to include a link in the description of the form that points to a non-fillable document in which the definitions are elaborated. This document does…
-
Form not scaling properly from desktop to mobile
Hi Community, Please may I ask advice on how to improve the scaling of my Smartsheet form when it is loaded on a smartphone? The desktop version looks perfect but when I open it on my phone it is cut of on both sided and only if I turn it to landscape it looks as it should. Much appreciated and stay safe, Kyle.
