-
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…
-
No Email Valiation option for Multiselect contact
Hello Team . I would like apply the newly released feature of validation in forms for email. I have requirement that i should allow multiple task owners but when I check in form for multi select contact email validation option is not available. it is available only for single task owner option. any worksaround for this?…
-
Customizing Form - No Logo & Form Title in Side-by-Side Format
We like being able to customize the appearance of our forms using a background and logo. When I switch from a "Vertical" form to a "Side-by-Side," we lose our logo and the form title. Screenshots attached. Am I missing something?
