-
Clear previous values from Dynamic View details panel fields
I would like to see an option to clear the previous entry in a row inside a Dynamic View. I understand that the dynamic view displays the current value for any given field inside the details panel. But if this is a field that routinely needs to get updated, I would like to see an option to default to blank. I want the…
-
Edit fields directly in 'View Summary' in Dynamic View vs. using Details Panel
It would be much more efficient in Dynamic view for editing fields if you could just click into the field and edit it right there instead of having to click on the field, wait for the Details Panel to open, then scroll through the list of options and enter the data into the details panel. From an administrator point of…
-
MAXIF, MINIF, AVGIF Formula Capability
It would help to have the IFS functionality and combined statistical functionality MAXIF, MINIF, AVGIF, MAXIFS, MINIFS, AVGIFS similar to the current SUMIF and COUNTIF. IFS can shorten multiple nested IF statements and easier to formulate, read and understand when referencing multiple conditions. The combined statistical…
-
Freeze columns in a report on a dashboard
If a column is frozen on a report and that report is used in a dashboard, it would be helpful for that freeze to apply when viewing the report on a dashboard.
-
Logic for Required Fields on Forms
I have a form that I am working on where I would like this logic: If box is checked, then field is required I spoke with support and they informed me that this is not a currently available feature. What I'm trying to do on my form is have it so if the user checks a box that they want someone to reach out to them, then they…
-
Update Okta SCIM Connector to Deactivate instead of Delete SmartSheet Users
Currently, when integrating SmartSheet with Okta and leveraging SCIM provisioning, the "Deactivate Users" feature on the Okta side will Delete the user's SmartSheet account, even if they are licensed and own sheets. This is problematic for automation purposes and results in pain from both security & user experience…
-
Merge cell functions
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
-
Set a Min-Max for Axis on Charts
I really like Dashboards and how it can visually tell where a project is at. What I do not like are the fluid charts. I would like to be able to set a Min-Max axis instead of having the axis change as items progress. Case in point with this script update - the min is 86% and the max is 102%. I want it to show from 0-100%.
-
Data Shuttle SharePoint Formatting
I was recently advised by the support team that it is not possible to lock formatting on the destination sheet in SharePoint which defeats the purpose of having this as every time the job runs it clear out the formatting and spacing of columns in SharePoint. Ideally, the data shuttle would only update the data points…
-
Format Painter for Summary Fields
It would be amazing to have the format painter be available for Summary Fields. It is incredibly cumbersome to format each individual summary field when you are creating many that should be formatted to the same number type, decimal places, etc.