-
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…
-
How to get feedback on common terminology on multiple terms
I am trying to get everyone on the same page with our terminology, I would like to have a grid with all of the terms and put out a form to members of the team to get their definition of the term, collect them to see where common ground in, then have a meeting to finalize the term where everyone is in agreement. If I had…
-
Web Form Update Multiple Sheets
Hello, I need help figuring out how to have a web form update multiple sheets based upon location information. Basically I have put together a web form that will do a site survey of hotel rooms for renovation. We are surveying several sites at a time and instead of creating 20 different web forms that update 20 different…
-
How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
-
Add data to columns using a form
Hi all, We have a sheet with thousands of unique orgs and need to collect additional data from them after signup, like bank details, a logo upload and user email address. Each org has a unique company number. Is it possible to use that as a unique identifier of the org so that the form will use the data entered by them to…
-
Is there a way to send an alert based on a non-contact list field?
I am trying to create an application in which users make a request of their supervisor and the supervisor approves or denies the request. I created a sheet with "employee name" as a contact list and "supervisor name" as a contact list. When I fill out the form and enter names in those fields, SS doesn't pick up that they…
-
Can you submit a document from a form and place the new row based on sheet heirarchy?
I have several vendors working on the same project. Each has a set of required deliverables that have to be submitted at regular intervals (weekly, twice monthly, monthly) during different project phases (concept, design, installation). I would like to use a sheet to track the submissions and create a form for them to use…
-
Update Request Results showing data that was deleted from Update Req. Form
I am sending an Update Request (UR) form to employees to have them tell me how many hours they worked each day. The smartsheet is prefilled with 8 hours each day. So when the UR form get to the employee, they just make adjustments as needed. In the image below, the employee received the UR form. Deleted 8 from the Hours…
-
How to open a form in the Mobile App using a web link/url
First question, I guess, is can a user, who does not have a Smartsheet account, use the Smartsheet Mobile App to enter data into a form? Now the real question. I want to configure a dashboard for maintenance workers that has links to several Smartsheet forms that they fill out and submit. I want to use the barcode…
