-
Duration Having Different End Dates
Hey All, I built out a strong sheet using strong heirarchys with a focus on predecessors looking at a few key dates. When there is a predecessor, the duration column seems to act different. Sometimes a "1 day" duration sets the end date one day forward. Sometimes a "1 day" duration sets the end date to today. There are no…
-
Smartsheet as Data Entry Form with Intertwined Filters in Drop-downs
Hi. I need to upload an Excel spreadsheet to have some of the columns there filled with text and dropdowns. The problem I am facing is that I would need the different dropdown filters to be intertwined (that is, if I have two columns with one named Continent and another one Country; making sure that when I do select in…
-
Any workaround for Primary column being the first column in a grouped report?
I actually feel a little silly even asking this, but I have a user request to do move a couple of columns to the left of the primary column in a report that uses Groups. Unfortunately I do not have a great response and I hope the collective awesomeness of the Smartsheet community has a better answer than "I can't make the…
-
Smartsheet Control Center - Delete Predecessors
Hi all! I have a question about control center. I want to make a global update but it's not possible in a predecessors column. Context: ~1200 projects already provisioned ~500 have data related to the predecessors we don't want to lose So I THINK I can remove the predecessors from the blueprint sheet itself and then…
-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
-
Column Descriptions in Reports
Column descriptions from sheets should also be visible on all reports using that column. It is important information for anyone using a report, just as it is for those viewing a sheet. Thank you
-
Increase the limit within Contact List column
Currently there is a limit of 20 contacts within the Contact List column, which is not sufficient for our needs. It would be great to either increase the maximum to a significantly higher number, or removing the limit whatsoever.
-
Can I filter by columns, not rows?
Hi. I'd like to filter a Smartsheet like this… … show only rows where (<column4> is checked OR <column8> is checked) Is this possible? I can only see filtering by row values, not column values. It is not practical for me to transpose the Smartsheet because the primary column has long text and contains over 100 rows.
-
Add a "Strict" Option to Auto Number Columns
The situation is if a row is copied from one sheet to another, the Auto Number unique row ID coming from the source sheet will keep the same auto number on the target sheet. This results in duplicate Auto Numbers potentially, which causes duplicates in what should a column with unique values.
-
Control Center - Ability to reorder columns, or reset all columns to predefined order
Please add the ability to 'reset' column order across sheets to match the template. Currently in control center, you can add (or move) a single column to a single destination point. As I understand it, that destination is based on the column position number. So although you may be showing it going in between "Assigned to"…
