-
"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…
-
Allow a column formula to be from a fixed cell
We regularly need to repeat one value (like 'industry') to appear on each row of our sheets so that when we pull data together we can slice and dice more easily. These are often hidden columns so they don't annoy our clients. The challenge is that we would like to take the singular reference of 'industry' from our project…
-
Column Finder
Provide a better way to find a column in sheet. For sheets with many columns, it is sometimes difficult to locate the column that you are looking for. It would be better if there were a dropdown that listed all columns in alphabetical order so that selecting it takes the focus to that column.
-
Show or hide columns by grouping (in Grid View)
Similar to the 'Group' and 'Ungroup' functionality in Excel, it would be helpful to select multiple groups of columns then have a way to categorize them as a group, then be able to toggle/filter the Grid to show only the columns desired. Use case example, you have columns for each month of the year and multiple years but…
-
Quarterly Planning - Looking to improve collecting team responses
I am in the PMO for a large engineering organization. Currently we have a large portfolio sheet (Control Center Summary sheet) that captures all of the information about each project. In our quarterly planning process, for each project we have the PM input their scope and select which development teams they need support…
-
Merged: Add Column Type 'Time' in 12 & 24 hour format please
This discussion has been merged.
-
Column Formulas Display Forms
We have a Control Center solution and forms that are tied to RAID logs and more. We have no way on a FORM to automate a project name or ID We would love (like on Card View) for a Column Formula to show static information on the form that pulls from the sheet. OR the option to pull Sheet summary data to the form. This would…
