-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
-
Transpose Webform Results
We are collecting quantity and item descriptions via webform for internal supply requests. Each row is a request. The first several columns in the row are the requester's information (Name, Dept., etc.). All other columns in the row are corresponding quantity and item description "pairs", such as, "Stapler Qty", "Stapler…
-
New Web Form rows being added to the middle of the sheet.
Hello guys, My subject really says it all. I have a Smartsheet, for which I have created a basic Web Form. Unfortunately, every new row added via the Web Form is deposited into row 63, whereas the sheet currently populated to 21 rows down. I used to have an 'auto-number' column, which I removed as per instructions (i.e.…
-
Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
-
160 character limit in field (used for sms)
Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.
-
Formulas and Data Rollup
Hi, I am in the process of putting together a sheet that logs the amount of production each day. As a bit of background we are an aggregate manufacturing and contracting business and what i am trying to do is have a sheet that tracks the amount of production of each product per day. I have created a sheet with all the…
-
Auto-create form
I have a sheet that has about 100 columns, the column title is the category, the first row is a question. I know I could export it and concantate the header + first row, but that look bad and would interfere with reporting, etc. It there a way to create a form where it uses the first row as the "help text" or some other…
-
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…