-
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.
-
Form: possibility of adding multiple raws as a form request result
Hi team, I am wondering if there is the possibility to fill in a form, described below i need to request the shipment of multiple parts to a customer, so the form will be like: first part is all the same (customer name, address and so on), second part is the part number, description; can be multiple parts for the same…
-
Publishing vs. Sharing Forms -> Reports -> Dashboards
Hi! I have a sheet the collects information through a form. So, a user submits a request through the form, it gets recorded in the sheet. One sheet holds all user requests. I have a report created that filters the rows based on the current user (and the email in the original form). This report is then displayed in a…
-
Using field from sheet to pull data into a form
Hello. Is there a way to use a field that is defined on a sheet to pull associated data into a form? For example, if I have a request ID for help desk tickets. I want to use a form to query or pull in the data from a specific Help Desk request ID, allowing a user to see what is in the record. Then, I'd like them to be able…
-
Return Column Names AND values from row in a reference column
I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction items completed. Each row identifies crew, date, job number, etc., and the remaining…
-
Dynamic Forms
Hello I have my project plan with certain people assigned to tasks. Each week i would like to have everyone fill out the percentage they are complete on the tasks that are associated with the week via form. I was wondering if in the forms i could have the user select their name from a drop down then see all the tasks they…
-
Forms with formulas
I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back through the application to avoid sending separate emails. The formula is submitted to…
-
Created form is it possible to display autonumber
Hi, I have a form to created that collects data where in order to avoid storing personal information I have set up a column assigning autonumbers to every case. Now the process is that the from is filled in by one team, the second team receives a notification to update. So we need to make sure the Auto number/ case number…
-
Vaccination Status/Testing Report
Does anyone have an easy solution to tracking employee weekly testing? My thought is that any employee that shows as unvaccinated will receive an alert each week to upload their test results. (I don't have a problem setting that up). From there, if an employee doesn't upload the test results each week then an alert will be…
