-
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…
-
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?
-
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…
-
Restrict Date column Based on another date column
Hello Everyone, I have two columns: Entry Date and Execution Date. I am trying to restrict the Execution Date to allow only date values that are after the date of the Entry Date value. for example: For Entry date, the value is:1/1/2023 The Execution Date: should only allow dates that are after 1/1/2023. is this possible?
-
I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the…