-
Filters to be synced between sheet and report
User of our Smartsheet based solution would like to have an option to filter one sheet and keep that filter synced on the report. That might be beneficial especially with large information set to have that "switchable" option.
-
Formula Helper
Maybe I've been spoiled by Excel, but I miss the formula helper. It would be great if SS had such a thing, it would make creating formulas, especially the complex ones, much smoother.
-
Viewing window for Formulas
There needs to be a way to view formulas in an expanded view. Currently, it's tough to see extra commas or discern between a curly bracket and regular and so on. This is especially difficult with long and/or complicated formulas. Without a formula helper like in Excel, being able to expand the view is crucial and save our…
-
Update requests automatically clearing.
Could a function be added to update requests that allows them to automatically clear from the sheet after X amount of time if left incomplete? This amount of time would be set by the sheet owner/admin, such as 12 hours. 24 hours, etc. I ask because we have many users that fill out a form in the morning and receive an…
-
Enhanced Stacked Graphs or Heat Maps in Dashboard
Reports with multiple source data such as Project Manager, Size of Project, and # of Projects per PM- Should be able to translate nicely into a stacked graph. Have yet to find a way to do this without being suggested that we need to create a metrics sheet for each project to then roll into a portfolio metrics sheet. If the…
-
Multi Select Drop Down on Sheet Summary
Currently in Sheet Summary, there is no option for a Multi-Select Drop down field. The request is to incorporate multi select to the drop down field option within Sheet Summary.
-
Like Button / Acknowledgement emojis for Comments
Would love to be able to acknowledge a comment/callout within the conversation feature without that action over-riding what appears on the Latest Comment column. i.e i want to acknowledge that i am being tasked with something via the conversation feature by entering a "thumbs up" or "eyes" emoji, without having to override…
-
Open in New Window option for Summary Sheet-based Reports
For reports sourcing from Sheet Summary Data, you would like to be able to: right-click the Sheet Name link and "open in a new window" You could do this only if the the report is Row-Report sourced. Would like the same functionality for a Summary Sheet Report.
-
Please add a ROW() Function
This simple function would enable (or simplify) formulas. Autonumbering is the current alternative but requires a column and is clunky. ROW() is helpful to grab cross-sheet data via INDEX when there are multiple sheets with the same row structure but different access permissions.
-
Back to Basics: Formatting in Request Approval
Hi The format of the request is basic and doesn't allow any areas of importance to be highlighted. having the ability to add a single colour and highlight / bold / italics / underline would enhance the request. In this example, not being able to bold the two of the words and change the colour means they can get missed.…