-
Symbol Formula for values
I need to create Symbol Column Formula to display the following color symbols based on data in another column: Red symbol If value is in Vacation balance column is>= 175 Yellow symbol If value in Vacation balance column is< 175 AND >= 160 Green symbol if value in Vacation balance column is <160 Help?
-
Would auto number duplicate a value if a row is moved to a different sheet?
Hello, I currently have a sheet that assigns an auto-number value for each row. Upon certain actions taking place, this row then gets moved to a different sheet. Because that row got moved, would that free up that specific auto-number value to be used again? I am hoping not as we are looking to use this as a unique…
-
シートの「列名」と「列の説明」を抽出したい
こんばんは。いつもお世話になっております。 使用しているシートの「列名」と「列の説明」を簡単にエクセルへエクスポートすることはできないでしょうか。 「列名」は「シートのエクスポート」操作で抽出できるのですが、「列の説明」を一つ一つコピペするのが大変です…。 何か良い方法があれば教えてください。
-
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…
-
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…