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…
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…
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…
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…
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…
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…
Is there a way to view reponses in the form view instead of just being able to view them as a spreadsheet?
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…
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"?
Hi, I'm trying to create a web form using a Smartsheet with about 30 questions in it, and I want to add in check boxes so that the user can answer a question Yes or No. However, the only way I can think to do this is to create the question as a column, and then create a seperate Yes and a seperate No column to give me the…
