-
Using Forms, I want to include a link to another Smartsheet that is accessible via cellphones
Hello! Employees report their absence using a Smartsheet "Attendance" form, usually from their cellphone. I've created a "picture map" on a separate Smartsheet grid to show new employees the different buildings and managers and linked it to my form (it's pretty confusing with 5 of the buildings on the same street). The…
-
How can I drag a file from Google Drive to a Smartsheet form?
Hi. Is there a way to adding files to a Smartsheet form directly from Google Drive without having to download it to a computer and then uploading it again to the form?
-
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…
