So I've been trying to figure out a way use have an automation transfer lines to a new sheet but then remove the extra columns. I'm ok using a helper column and then transfer it to a 3rd sheet but I cannot figure out a way to do it. Basically I have several sheets I want to create where a long sheet gets transferred to…
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…
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…
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…
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…
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 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
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.
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.
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.
