-
Toggle Option to for Sheet Viewing
Hi, I love the desktop app! My one issue with it is it always opens the very first sheet I ever opened in the app. It won't open the last sheet or open to the home page. I looked for a settings option, but there isn't any settings available. Please add a settings option for users to either open the last sheet they had open…
-
The $ Formula
A consultant I worked with was tasked with building a graph showing our portfolio growth over time. The graph needed to be a 12-month trailing horizontal axis which uses the (already recorded) dates for when any new project is triggered for provisioning. On the vertical axis, we wanted to track the sum of the project sizes…
-
Merged: Individually hide and unhide columns
This discussion has been merged.
-
Can you copy specific rows to a new sheet without bringing over child rows?
We do our weekly reports (Good, Brutal Facts, and Help Needed) within SmartSheet (Have 5 levels of Hierarchy with "+" and "-" icons), and our process has gained traction with other teams. We are looking at how to scale our process to accommodate another level of leader (Currently goes from Managers -> Director and Director…
-
Line Breaks in Text Fields on Forms
We would like to be able to use line breaks in the text fields of forms. For example, if you are typing data into a form linked to a smartsheet, it would be helpful to have the capability to skip lines or "enter" to the next line to continue inputting information. This would be helpful in both data organization and…
-
Merged: Find and Replace in Formulas Please!!
This discussion has been merged.
-
Dashboards Updating With Weekly Metrics
Hello, I'm trying to figure out how to have our dashboard update automatically when we work off of weekly periods. In other words, we are adding daily metrics that tally into weekly periods. Those weekly periods are collapsed and saved for historical data. Currently, I have to edit the data in the dashboard widget every…
-
Grouping of Sheet and Row results in Search now available!
Hi Community! Great news, now row results that are inside sheets will display as a child under the sheet in your search results, instead of their own parent row. This improvement allows us to show you more comprehensive results, displaying the relationship between the sheet and row in a more contextual and improved way.…
-
Are Admins the only ones who can create new sheet from Template?
We would like to have one of our Editors have the ability to create new sheets from a template in the workspace they're shared to. However, it appears that only admins have that ability. This seems unsafe for workspaces that have a lot of customization that could be modified by a user that really only needs Editor…
-
Nested if & countifs to generate a prefix based on number of occurrences
I am trying to get this part of a concatenate to work but keep getting #unparseable. The latter part of the concatenate works and generates a unique identifier for the project. However, the beginning section is meant to generate a prefix based on whether this project is the first, second (b), third (c) etc. project with…