-
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…
-
Merged: Unhiding Individual Columns
This discussion has been merged.
-
Unhiding Individual Columns
Hello, Having to unhide all columns at once can be overwhelming for new users. From a developer stand point, it's horrible. I usually have to unhide all columns to develop automations and procedures through multiple sheets and reports. Just to properly set up a lookup function can be difficult for new employees who haven't…
-
Multiple contacts in a sheet summary field
Hi, We use control center and we love using Sheet Summary field to bring in certain values from Specific Sheet (using cross-sheet reference formula) then we feed that info to column with column formula so every row will have the same info. We noticed we can't do this for Multi-Select Contact in Sheet Summary if column type…
-
Merged: New automation to copy cell content to another column (for capturing baselines)
This discussion has been merged.
-
Custom Columns in 'Sheet Summary' Report
This report is amazing and could be super useful if we have the ability to customize the column names according to our team's/organization's needs. The columns in the 'Sheet Summary' report get auto-generated and are not based on the source sheet(s). We need to be able to customize these as my team uses different legends…
-
Merged: Columns - Increase the Maximum Column from 400 to 1000
This discussion has been merged.
