-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Parent dropdowns
It would be amazing if there were a way to edit or add to a parent dropdown that can be used and updated across all sheets. This would make more builds possible that require many dropdown menus. Many sheets use the same dropdown, but then if anything is changed or added to it, it becomes a nightmare!
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
Mass Uploads and multi-sheet interaction
Hey all. This is likely a stupid question that has been answered before. None of the searches I have done have had quite the answer I was looking for. I am working my way through the core app learning path, but I haven't found what I am looking for. There are what feel like hints of it, but nothing that has clicked for me.…
-
Critical path viewed when linked to a parent row
It would be nice to have the critical path show when linked to a parent row. I have a parent row (e.g. Testing) where the children (e.g. test 1, test 2, test 3,...) are performed in parallel & have the same finish date, so I often link the successor task(s) to the one parent row vs. each individual test task rows (can be…
-
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,…
-
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.
-
Unable to transfer ownership of specific Smartsheet items
I used to be able to click share for a specific sheet and make someone a owner of a specific document. A few weeks back, the "Make Owner" option stopped showing up. Is there a reason this option was removed and what is the workaround?