-
シートの「列名」と「列の説明」を抽出したい
こんばんは。いつもお世話になっております。 使用しているシートの「列名」と「列の説明」を簡単にエクセルへエクスポートすることはできないでしょうか。 「列名」は「シートのエクスポート」操作で抽出できるのですが、「列の説明」を一つ一つコピペするのが大変です…。 何か良い方法があれば教えてください。
-
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…
-
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…