-
Updating Dashboard
So I have created a Dashboard with Metrics and Graphs only to learn that as the underlying data in the sheet is updated the widgets do not update they are static. Given the number of dashboards to be built it is not feasible to manually re-point the widgets to the latest data. So I need a workaround. Given that the widgets…
-
No restrict to dropdown values on form
On the sheet, if I dont check on "Restrict to dropdown values only", then I can type a new value into the dropdown column. But on the form, I cannot type a new value, even I choose not to check "Restrict to dropdown values only" on the column properties. Is there any way that I can create a dropdown field on form and still…
-
Form not capturing submissions
Hi, Am experiencing an issue on a brand new sheet/form where submissions are not being captured. No filters. No hidden columns or anything. Shows that five entries have been submitted (all my tests), but nothing is showing up on the grid view. It's a blank sheet even though I see the confirmation pop-up and the pop-up that…
-
Enhancement Request: Dropdown for Forms
Quick request, likely will come to naught, but here it is: Several uses cases recently require designs with multiple forms. Useful would be a convenient way for end-users to access them (for submission, not editing). Perhaps a dropdown maybe in all that wasted space in the new GUI design* Other solutions, like a Dashboard,…
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Forms, Formula and fixes - Oh My!
Hello, I have created a web based form in which the user fills in certain information. As part of our metrics we need to keep track of when an quote is finished and completed. I have a date column for the quote finish and a checkbox cell for complete status. Our reports use the checkbox cell as the primary filter.…
-
How to manage Order with multiple items
I'm creating a form to collect Order information from users and facing a difficulty with an order having multiple items. I want to create a form which allows users to input multiple items in one order request. Each item will have each price and quantity. How can I do that in smartsheet? Thanks.
-
Web form and linking
Dear all, right now I am struggling a bit as I'd like to implement a web form that is forwarding information into a master table from which the new added row should be directly linked to further sheets to be evaluated and qualified. I had a look in former threads and tried the reporting function, but this won't let me…
-
Drowndown list accessible via link to other smartsheet - Form
Do you know how we can create a form where one of the filed is drowndown list to be chosen from the list stored in other sheet ?
-
Auto pre-populate a web form
Good day, I would like to pre-populate a smartsheet form with values in certain columns. I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text. However, I want to avoid having to create each URL by hand, this will take forever. Is there a way to automatically generate the…
