-
Can you have hidden fields on a form become visible depending on value in another field?
So on the user end of the form, I have, for example, a Yes/No question about a meal. Question: Will you be attending the luncheon If answer is Yes, then additional fields will appear asking about meal choices, accommodations, etc. If the computer says No, then the fields regarding the luncheon will stay hidden. Is this…
-
URL String Form Erroring on Submission
Hi I have set up a URL string to grab some data from one Smartsheet that the form is generated from that is used to effectively tie together two Smartsheets with a common key and enable data from one sheet to be bought across to the other using index matches within the 2nd sheet based on this common key. The issue I have…
-
Scoring Formulas
I'm looking to convert a process to smartsheet, but am trying to determine if there is a formula to make the concept work. Currently I have a form which asks a series of questions - each question has a single select option of "yes (description)" "no (description)" and "n/a". For each question, there is a score associated…
-
Lead Tracking In Smartsheet
I need to be able to track leads sources in Smartsheet. There is currently no ability to passthrough the URL of the embedded page for UTM parameters. None of the options for fields support scripts to manually pull that URL for example; <script> document.getElementById("demo").innerHTML = "The full URL of this page is:<br>"…
-
Weekly Timecard
Hey Everyone, I'm searching for help with developing a time card solution using the form feature. I understand there are already templates in Smartsheets but none them seem to work. The closest template would be the "Weekly Time Card". However it's not really weekly but daily when we referring to the process in filling out…
-
Hierrarchy in web forms
I have data broken out by region (AMER, EMEA, & APAC), and there is budget information contained in each row. The region is a parent and the corresponding rows are children. This allows me to get a regional budget summary. Is there a way to maintain this hierarchy (parent/child relationship) when rows are created using web…
-
Conditional quantities for pricing sheet?
Smarties, I am creating a pricing form and am stuck on a formula. In the example, the first 4 widgets cost $10. Each additional widget is after 4 widgets is $3. In the preceding cell [1-4 WIDGETS], I have a single-select dropdown of 1, 2, 3, 4, 5+ (as I need these numbers to count the number of widgets sold for another…
-
Formula Interferes with Form Data
I have a sheet where the first row is full of SUM(row2:row40) functions. This sheet has a Form that submits new data and I want the new data to be included in the totals at the top. I only have 10 rows filled so far, so I expected a form submission to show up on row 11. Instead, it shows up on row 41 so it is excluded from…
-
Forms Customization
Hello, It is possible to customize forms? Like put background images or simple change font color. My main objective is to put an image of an enterprise in form to make him more professional or with a specific customization. Thank you.
-
Include Column Description in Update Request Form or Form to Update Existing Rows
It would be incredibly helpful if the column descriptions were included in the update request form. We will request information from users who do not have access to the sheet and likely will be unfamiliar with the type of information that should be included in the column. Forms allow help text, this should also be a…
