-
Is there a way to conditionally copy the value of one cell to another?
I am trying to create a modified auto-numbering scheme where the numbering is based on a parent/child relationship. I think I am on the right track, but have hit a roadblock. My end result should be a calculated ID that is not overwritten when IDCalc changes. I would like the value of IDCalc to populate in the ID column…
-
Lock a shared sheet into a standard format/setup
It would be great to eliminate the frustration of your view on a shared sheet being rearranged by cell width and wrapped text done by another user. Individual users should have the ability to save their own view of the sheet, or clear all their customizations and have it revert back to the original default view. Could work…
-
Change Project type via Smartsheet
We generate all our projects from Smartsheet. When doing so, the default project type is "confirmed" the problem is that all our projects start out as tentative. There should be a way to change the project type from Smartsheet.
-
Can a Form have multiple entries and have them display as multiple lines on the smartsheet?
I have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in the smartsheet order log? If they do have to enter a form entry for every part they want…
-
Difficulty with number vs text format, especially when using primary column as match range
Currently I have a primary column in sheet 1 which is a value of 3 digits, all of which are numbers. These numbers are generated by the auto-number column type. I attempt to use this primary column as a match range to pull information with an index & match into sheet 2. Performing a test using ISTEXT on sheet 1, all…
-
Calendar App - Dual Login
Enhancement Request: Take away dual login for Calendar App This causes issues with users accessing the calendar app in general (not wanting to dual login) as well as issues with dashboards as mentioned in this post: It is a continuity issue in the Smartsheet environment to not have the link between Smartsheet Main &…
-
Expand Highlight Changes Feature
There would be a lot of value for me if the Highlight Changes Tool could have MORE user defined parameters. Filter for Highlighted Changes Identify Highlighted Changes per User Differentiate Highlights per User option Identify Highlighted Changes by Custom Time Thanks!
-
Convert Report Filter to Sheet Summary Formula
I have a number of reports with sophisticated filters that use an important master sheet as the source. I'd like to have the ability to create a formula from a report that I can paste into the master sheet's Sheet Summary section in a COUNTIF or SUMIF format. This function could be in the File menu under Save Filter As...…
-
Sort Order of Columns with Dropdown List -- Feature Request
Please consider offering more flexibility in the Sort functionality for columns with dropdown lists. I appreciate the column sort order following the dropdown list's order. But, it is missing a couple things. Allow the user to optionally select this behavior vs. sort on the actual alpha-numeric value in the column…
-
Control Center Automation Ability to Trigger Document Sets Specific to Project Category
We would like the ability for Control Center automation to be configurable to trigger different document sets based on the category selected in the project intake sheet. For instance, if the new project request is Category 1, we would like to trigger a set of reports and sheets specific to Category 1. If the new project…