-
Sum of children while keeping column formula
In my sheet I have columns with formulas that I would like to keep as applied column formulas. I also categorize my row's by creating children under a labeled row. Within the labeled row I would like to Sum up the figures contained within the columns that have column formulas however when I try to do that, the system wants…
-
Sort column containing dates in chronological order
· Problem: It is not possible to sort a column containing dates by chronological order · Use Case: list of annual leave for employees working on a project · Ideal Solution: Enable sort by: chronological order for a column containing dates
-
Creating Column with fomula using Control Center returns UNPARSEABLE
Hello everyone! I am running into an issue when using Control Center to create new columns with formulas across my active projects. I have already tried the column with the formula in one of these sheets and everything works fine there. However, in testing and creating the columns using Control Center, it returns the…
-
Creating a count for a Column
So I have a column I am trying to get a count of by year for a Metric dashboard. I am using the following formula: =countif([Completion Date]:[Completion Date], ="2023"). This formula is not working and I am not the best with them. Can someone help me figure this our?
-
Where can I find column ID in smartsheet?
For row, this is very easy. But it's not clear for column. Where Сolumn ID?
-
Editors Reordering Columns
Hello all, As I've read in Smartsheet Articles, the only roles that can change column layout are Owners and Admins. However, in one of our workspaces, we noticed an Editor changing the order of the columns in a Sheet. Are we missing something and is this expected behavior? If no, what can we do to fix this? We don't want…
-
Copy column on one sheet to another column on another sheet (and update when new rows added)
Is there a way in Smartsheet to have Column A in sheet 1 automatically copied/linked over to Column A in sheet 2? We need consistent building names across 12 different sheets, but we want Sheet 1 to be the only place new building names are added. Is this possible?
-
Automation Lock Column
We need to auto-lock a column based on criteria like we can lock rows within the automation workflow.
-
AUTO TASK ID HAS A FLAW - URGENT NEED TO FIX
The Auto Task ID column is auto-generated by Smartsheets and is supposed to be a UNIQUE identifier. Shockingly, it generated two of the same IDs, this is a SMARTSHEET bug. (Several formulas rely on this ID to be a unique identifier). Perhaps somehow two users saved the sheet simultaneously or something to create this bug,…
-
How to set as a default in Contact column the person that added a new row?
Hello, In the Sheet I am using, I have a contact column named Requester which is the person who has added the request. The requests are added directly into the Sheet. I would like to automatically set the value of the Requester to the person who added the new row. There is the action "Assign people" in workflow, but I…
