-
Hide Unhide Columns
Hi @Genevieve P., @MMcLain, Last time I checked the Community Discussions on the subject of "hide unhide" under the categories of Smartsheet Basics or Product Feedback there were 1,076 posts about the subject going back over more than 5 years. It seems like some product improvements need to be delivered in this area! While…
-
Symbol Formula for values
I need to create Symbol Column Formula to display the following color symbols based on data in another column: Red symbol If value is in Vacation balance column is>= 175 Yellow symbol If value in Vacation balance column is< 175 AND >= 160 Green symbol if value in Vacation balance column is <160 Help?
-
Would auto number duplicate a value if a row is moved to a different sheet?
Hello, I currently have a sheet that assigns an auto-number value for each row. Upon certain actions taking place, this row then gets moved to a different sheet. Because that row got moved, would that free up that specific auto-number value to be used again? I am hoping not as we are looking to use this as a unique…
-
シートの「列名」と「列の説明」を抽出したい
こんばんは。いつもお世話になっております。 使用しているシートの「列名」と「列の説明」を簡単にエクセルへエクスポートすることはできないでしょうか。 「列名」は「シートのエクスポート」操作で抽出できるのですが、「列の説明」を一つ一つコピペするのが大変です…。 何か良い方法があれば教えてください。
-
Sheet Compare to highlight differences
The ability to compare sheets that have a similar layout and list differences between them. I know using Control Center and Global Updates to rollout projects and project changes will solve this issue but I have current/legacy projects that were manually created. It would be awesome if I could compare sheets in an attempt…
-
As an Admin I can't add columns but can do conditional formatting and formula column conversion
Hello everyone, My boss gave me Admin permissions on a sheet in order to amend some columns. I noticed that as an Admin I can have access to some Admin functionalities (like converting a cell to a formula column or amending the conditional formatting) that were precluded to me as an Editor, but I am not able to add columns…
-
Separate Text/Number Column Type
As the owner of a data sheet, my data cleansing would be significantly reduced if the column property could be set as a text only or a number only. When I have a column in which I would like a number to be added, some people put "TBD" which messes up my connected dashboarding calculations. Can we please have the option to…
-
Parent & Child Formulas in the Same Column?
My sheet is structured as a sort of tiered task checklist. There are several Parent rows with varying numbers of Child rows. There are two columns that are involved with my issue: the first is a "Status" column, and the second is a sort of "True/False" binary check labelled as "% Complete." There are no formulas in the…
-
Automation on columns
I would like to set up a notification automation for when all the criteria in the column is met. For example, I have a column that includes a checkbox with the column labeled "complete". I want to receive a notification when the last checkbox in the column is checked, so that I know that all tasks have been completed on…
-
How to create a sum column formula in Sheet Summary
I have a formula base column that I'm trying to get the sum in Sheet Summary and I'm getting the #invalid operation error. I have some criteria for the sum I'm looking for and I did the exact formula for the [DDA Hours Used] column, so I'm not understanding why this one isn't working.
