-
Adding a New Card in Card View Auto Adds to Uncategorized
Hello! In my sheet, I have the card view setup to view by my "Parent" column which is a dropdown column type with a column formula that pulls the Parent task name of my row, because that's what I need my columns to be. When I'm in the card view, and I click the "+" icon in my lane to add a new task, I enter the name and…
-
Why do some columns (fields) not appear in a new form?
Hi, I'm a new user. I created a Smartsheet with roughly 60 columns for a survey form, but not all of these appear when I create a form. Forty-eight (48) of these columns are Dropdown (Multi Select). Each column represents a month of the year for 4 different categories, so that is why there are so many. In other words,…
-
Primary Columns in Grouped Reports: change label locations and move column
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…
-
Finding the closest date today with 2 columns of dates
Hi, I am working on a formula to show the next date from 2 rows of dates. I tried =MAX(COLLECT([Release]:[Release], [Live]:[Live], >TODAY())) - and it showed a date from the past. I tried =MIN(COLLECT([Release]:[Release ], [Live]:[Live], >TODAY())) With the same results. Any help is much appreciated.
-
Merged: More Stoplight Colors
This discussion has been merged.
-
Why can I not access the Document Builder feature?
Although I have an enterprise plan Smartsheet account, I have never been given the option to 'generate document', which is really confusing and unhelpful as I plan on using this feature along with the Docusign integration for a current work project. Could someone let me know how I can access this or why I can't access this?
-
Viewing pictures in Dynamic View without having to download the file.
There needs to be a way to view pictures and attachments in Dynamic View, like in sheets, without having to download them every time you want view them. I'm sure that Dynamic View was added after basic sheets and can't imagine why this functionality would be set up to force a download. This is the only function keeping us…
-
Hyperlink for mailto: in Reports, Dashboards and Grids
I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the…
-
Dynamic Data Validation with Columns from another Grid
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that serves as tracking tasks related to the projects in the master sheet. When People…
-
Help with IF(INDEX(MATCH
Hi all, First question in the forum. I'm in need of help with an INDEX(MATCH( formula that I've been using but now need to make conditional on another column. Essentially, I only want the INDEX(MATCH( formula to return a value when a column "Completion" is changed to "100%". I've tried nesting the existing INDEX(MATCH…
