-
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.
-
can we create an automation or other method of removing columns
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…
-
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…
