-
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…
-
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…
-
"autoNumberFormat" seems to be ignored
I am trying to add an 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…
-
How can I summarize information from Column Headers across multiple rows?
I am trying to summarize information from multiple columns within a Smartsheet to identify Columns that may or may not apply to a specific Team. Using the example below, I would like to summarize the Columns that apply to Dept 1 and Dept 2. For example, the desired outcome of the example would note that Department 1…
-
Creating a column from multiple columns, with conditions
I have created a sheet which is populated via a form for the auditing of stock. Each audit consists of 20 items. I'd like to create a separate sheet that only lists the items that have discrepancies. Sheet looks something like this… Would like the Discrepancy Sheet to look like this: So, the audit number, item number and…
-
"Select All" Functionality in Forms
Hi team, Is there any way to enable the "Select All" functionality found in Multi-Select Columns on Sheets (below, left) within the corresponding Form field (below, right)? I don't seem to be able to get it to display on either Dropdown, Vertical or Horizontal Checkbox display options. I feel like I'm missing something…