-
Hover to Discover on Dashboards
It would be useful to have a 'Hover to Discover' function on Dashboards, to add brief context to widgets without requiring users to click-through to open a new tab. Our organization displays contract performance data on Dashboards, and it would be useful to be able to add data context (e.g. data lag, or…
-
Return the full set of properties for every object type in Smartsheet
Before I explain my suggestions, I would first like to give some context on how I use the Smartsheet API. I develop implementations for SQL connectivity interfaces such as JDBC, ODBC, ADO.NET, etc. for various sources (one of those sources being Smartsheet). I use the Smartsheet API to get data for the main resources in…
-
Multiple selection dropdown formatting in Metric Widget
Hi all! As of now, when using a Metric Widget in a dashboard that pulls from a multi select dropdown field, the values appear like this (see image), a blue-ish/cyan color as a background. It would be great to be able to customize the colors or even better, from a consistency perspective, to have the formatting pulled from…
-
Have a way to hide the Submit button on a form with logic
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
-
Network Diagram (Process Flow) View for Sheets
Develop a new view for Sheets that displays connected tasks as a network or process flow diagram. Once you have identified the activities and their dependencies, you can visualize the critical path analysis chart (CPA), known as the network diagram. The network diagram is a visual representation of the order of your…
-
new GRANDPARENT() function
I would greatly appreciate a Grandparent function, especially since PARENT(PARENT()) throws an error. I know we have ANCESTORS(), but that gives you the number of ancestors and I need the specific ancestor value. Ideally, the GRANDPARENT() function would be GRANDPARENT( [reference], [# of generations back] ), that way it…
-
Merged: GRANDCHILDREN Function
This discussion has been merged.
-
Dynamic View Access
If this does not already exist, it would be great for viewers to be able to toggle to a dynamic view that they have been shared to from the source sheet without having to go to the launcher.
-
New Formula Error message #ERROR IN RANGE
Right now the Smartsheet formulas will pass through errors that exist in ranges referenced in formulas. This can result in error messages like "#INVALID DATA TYPE" in formulas where that is fundamentally impossible - making trouble shooting much more difficult. If, instead of opting for passing through any existing error…
-
Account for Budgeting Future Expenses in Resource Mgmt
This relates to Resource Management. I'd like the ability to add a date with the budget amount to future expenses. The budget amount is entered in the Project properties but not the dates in which you anticipate them to occur. If you add them to future Expenses (via the My Work -> Time & Expenses), it still counts them as…