-
Mobile forms link is requesting login/free trial even though security is not enabled.
Hello, I've created a form and have the security setting disabled so that anyone can submit, from anywhere. It works fine on desktop, but if trying to submit via mobile, it is sending users to an "explore what Smartsheet can do" landing page - requesting users to either try Smartsheet for free or login to an existing…
-
How to auto-populate hidden values for forms?
Hello, my name is Matthew, and I am working on a project that gathers data from clients. The goal is to receive documents from them and have them uploaded to SmartSheet. I would like to be able to send them a form based off a contact cell, but I am having trouble with this. The other issue is, unless they type what we have…
-
Is it possible to export a sheet as forms?
We often need to publish a report pulling data from a selection of columns, for a single row, sequentially on a page, and then the next row, etc (I.e. laid out like a document, not a spreadsheet). We currently use the Smartsheet add-on in google docs to do this, but it is frustrating and time consuming. Essentially what we…
-
Need Workaround Ideas for Automation Condition
Client submits file through form. I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on people to always set those 2 fields and save before attaching the file to the row. Without the conditions set,…
-
Best design for long forms with logic?
Hi, The ability to use forms and the logic options are really amazing tools. I see how the use of forms can increase the productivity of my team and eliminate a lot of emails back and forth with our clients. One use case we have is that there is a form currently in an excel format that is lengthy and comprehensive. I've…
-
I want sync a field across multiple sheet, being able to edit it from any of those sheets
Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New. When we agree that the team will work on it - we add the Unique identifier to the "Prioritization" sheet and the…
-
Can I set the default value for a drop down list to be a formula in a form?
I am creating a SmartSheet whose rows are filled with the submission of the form and I wanted to utilize the hidden feature of the form to autofill a field when the form is submitted. I wanted this field to hold a formula that would select a value from a dropdown menu upon submission of the form but every time I submit the…
-
Auto fill form for status updates
Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - if applicable. This value needs to be pulled from a sheet based on the region/function…
-
Sheet Linking
Is there a way to link one sheet to another sheet creating a drop down menu? Example: I am creating a form, but I want to the staff to be able to select the residents from a drop down menu. I have the sheet created with the residents information but I cant figure out how to link it to my "forms sheet' so that they are a…
-
Personal logo in Forms
Does anyone know why sometimes when you (I) create a new form, the label icon is "Smart Sheet" but sometimes it is my company logo and colors. I set up so that my company logo and colors are the default, but 99% of the time when I create a grid and turn it into a Form, it has the "Smart Sheet' logo and colors. I cant…
