-
Merged: Override Column Formula for Particular Cells
This discussion has been merged.
-
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…
-
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…
-
Ability to Change Column Type When Conditional Formatting Exists
I would like to be able to change column types without having to delete conditional formatting rules. Currently I have 20 columns that I want to change from Text/Number to Dropdown List. They each have 5 Conditional Formatting rules applied to them. I can't change the column types without deleting the rules first. I can…
-
Columns have reordered
I have a question about Smartsheet. I have columns in my sheet for Monday, Tuesday, etc. Somehow, Monday moved to the end of the sheet. So, now Monday is after Sunday. I looked at the activity log, and it shows that the columns were reordered. How can I get them back to the beginning of the sheet, other than by dragging…
-
New column type: Currency-only
I see there’s already an idea requesting a "Number only" column type, and I’d like to suggest adding a "Currency only" column type as well. Currently, I have to create several workarounds to validate certain fields we collect. For example: Ticket number or Purchase Order number fields should only allow numbers and have a…
-
Default Column Sort Priority
is the ability to create a permanent default sort on a column (status) a feature request that is in the works or that will soon be implemented? having to create a helper column seems more like a work around instead of a solution. How this isn't a feature already when you already have sooo many amazing features is beyond me.
-
Merged: Select columns feature in "Move a row" automation
This discussion has been merged.
-
Synchronize Column Description, Input Form Help Text, and Dynamic View Description/Help Text
Allow for synchronization/harmonization of Column Description and Help Text fields across Smartsheet assets. The Column Description in Sheet view could be the default source of Help Text for that same Column in any Input Forms based on that Sheet, as well as the Description/Help Text for that Column in any related Dynamic…
-
Formula Range
Hello Community, Is there a way to make the range for a formula start at a certain row and then continue on once other rows are created? I've found that leaving the end of range number blank or putting a future number row that has not been created causes the formula to be Unparseable.