-
Allowed Values depending on Value in another column
Dear Smart Sheet Users, as a newbie, I'm not familiar handling depending possible values in Smartsheet. We want to approve a deployment process. If a user chooses value 1 in column A during data entry then there should only be a sublist of possible users to send the approval request in column B - if a user chooses value 2…
-
Creating a Form with Row information
I am looking to create a form that populates information into specific rows, not based on columns. I see a few discussions from several years ago, but nothing recently to see if this is doable. Anyone know if this can be done?
-
Smartsheet Forms
Is it possible to make the Smartsheet forms "smart" and/or more sophisticated looking? The more my team uses forms to collect data from external individuals, the greater the need to have conditional questions and more sophisticated looking forms --- neither of which is possible in Smartsheet. While my team is starting to…
-
Question about embedded webform and filtered sheet in confluence
Dear all, I did some research about the following topic but somehow got stucked and every helping hand is appreciated. What is the current status: Currently we are using smartsheet (lets call it "project_overview") to keep track on all our projects. After a few years this list is quite big (around 700 rows) so we are…
-
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.…
