-
Can you link drop boxes in a web form?
I want to be able to select your name and your assigned support person populates the next block
-
Tracking Purchasing Approval
We are trying to find a way to track our purchasing process. I have created a sheet with a web form, but am having trouble with the approvals part of our process. Typically the purchaser would fill out the web form to request payment to a vendor or to themselves as reimbursement, then they need to get 2 approvals from…
-
Tracking Assets by location
I am not sure if this can be done in smart sheet. I need to track assets by location. There with be up to 50 assets by location and several thousand locations. I would also like t have the ability to add the bulk of the items from a location kit as all have common items with a few variables as to how many of each. All…
-
Using formula to copy row to new sheet as a child row
We have created web forms to retrieve new client information and new project information. Both forms contain the Primary Column "Client Name". I know we can link cells from one sheet to another. But what I'd like to know is if we can set a formula (or link a sheet) so that when a new form is submitted (and it is added to…
-
Updating a sheet with two web forms
I understand that SS will not update the same row from two separate web forms. Does anyone have a workaround for this. I want to use a web form to collect safety issues from employees. i then want to send the information to the employee's supervisors to have them take some actions and report what they have done. I know I…
-
Auto linking cells once populated by a web form
Hi! I am trying to use a Web Form to populate a "Master List" full of 30 columns of information. I would like the info located on that "Master List" to trickle down into 3 different "Sub Sheets" that present only selected info from the "Master List". However I am having trouble getting blank cells to understand that once…
-
Vacation Plans for the End Users
Hi , I'm trying to make a simple webform which will enable group of people to enter their vacation plans for the year. the way I see in the simpliest way . Name Surname Holiday Period - Start Date - End Date . but , in reality people may have vacations planned in different times so they should be able to select the…
-
Viewing Responses Individually as a Form Instead of Spreadsheet
Is there a way to view reponses in the form view instead of just being able to view them as a spreadsheet?
-
Webform: Request a Quote ID # (auto generated unique ID#)
I am attempting to use Smarthsheet to automagically assign and return a unique id # to the requestor (without any intervention) Steps: Sales Person: Fills out a 'Request Quote ID' (webform) SmartSheet, logs the request and returns the Unique identifier to the sales person for use in generating their quote. **end…
-
Populate field with name of file submitted through web form?
If someone uses a web form to upload a file attachment, is there a way to auto-populate a cell with the name of that attachment? For example, the form user submits a file named Test123.xls. Is there a way to auto-populate a cell with "Test123"?