-
Can an automation reference a column from a cell value?
I'm trying to track which users are granted access to various systems. What I would like to do is to have one grid which lists all the System IDs (and various properties as columns) with one system per row, and a unique System ID for each system. Then I would like a grid that lists each user as a row, and the column…
-
Merged: Edit Row - ability to hide columns
This discussion has been merged.
-
Calaulate activity health based on % complete and Planned Finish date
In my sheet I have a column "% Complete" and "Planned FInish". Is it possible to create a formula which can highlight the row color in red, blue or green or yellow if % complete is less then 100% and planned finish is over a certain date (example 10 Dec 2024). I am new at smartsheet, need help from our community.
-
Auto Number Column - what happens when numbers run out?
I have a sheet with an auto number column which I expect to get very large. What happens when all the available options for unique numbers are used? For example, once I have already used 001-999, does the next row start at 001 again, or will it stop populating numbers? Or will I get errors? I have chosen the option with…
-
Allow single cell references to be converting to column formulas
Currently when you want to reference a single cell in another row you cannot convert the cell formula to a column formula without getting a syntax error even though the formula works fine as a cell formula. I need this functionality as I am trying to figure out a work around to do round robin auto assignments for new items…
-
Merged: Grouping Columns
This discussion has been merged.
-
CONFLICT COLUMN (Shows where issues are when scheduling)
I have started to develop a CONFLICT column, that is, a column to show/ highlight where the same ASSIGNED TO/ RESOURCE/ MACHINE has been allocated on the same day, thus identifying potential conflicts in the schedule. The columns counts the number of instances where the START DATE and ASSIGNED TO are the same and only for…
-
Columns for file attachments.
Our organization uses Smartsheets for cross-functional communication, both internally and externally. However, sharing documents alongside this communication can be challenging. It would be helpful if Smartsheets allowed for dedicated columns for file attachments, making them more visible and easier to locate.
-
Dashboard charts by column instead of cells
When creating charts in a dashboard, allow users to chart based on columns selected rather than cells.
-
AutoNumber systemColumnType via API
I am trying to add a AutoNumber column type to a sheet It seems to work just fine The issue I am having is the "autoNumberFormat" seems to be ignored. I can go into the smartsheet.com and manually edit the prefix, and suffix, and starting number in the sheet and it works fine… but the API isn't applying this on column…
