-
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...…
-
Copy and Paste Column's
Need a way to copy and paste columns from one "standard columns" sheet to new sheets. This would be similar to a template but more flexible.
-
Symbol Explanations
Can we add a mechanism that lets a user hover over a symbol in a sheet or dashboard and get an explanation for the symbol For example, Green dot = Excellent, Red dot = Serious, Blue dot = task closed, Yellow dot = Watch. User should be able to define what the symbol means. Thanks.
-
Hidden Columns List
I would love to have a collapsable/expandable list of all hidden columns on a sheet with the option to unhide them from the list. This way, if I have multiple hidden columns and I just want one or two of them, I don't have to unhide everything to get to them. This would also allow you to look for columns that might be…
-
Control Centre Automatic Move Automation Rerouting
I have a Control Centre Blueprint that contains two sheets, let's call them Sheet A and Sheet B. Sheet A has a Move Automation that sends the row to Sheet B. I would like it to be that when Control Centre provisions a new set of sheets, let's call them Sheet A' and Sheet B', the provisioned automation on Sheet A'…
-
Reference Tracker
I was unaware of the limit of 100 cross sheet references. I've made some adjustments but am wondering if a tracker can be placed in the sheet Properties? That would be helpful to know where I'm at as I build out some rather larger sheets.
-
Using a formula to modify the contents of a multi-Contact cell
Hello, Here's the idea: Use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, it will SUBTRACT (or otherwise modify) that contact from the first cell. So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell 2: Contact2 Cell 3:…
-
Control Center Global Updates - Sheet Filters
Would love to have the ability to apply shared filters on a sheet via Global Updates. We have a project plan template in our blueprint and have created a standard set of filters (red tasks, yellow tasks, overdue tasks, etc) and would like to apply them to all active projects. The only option we currently have is to…
-
Group Columns in Grid
Hi! I use a really large grid-style Smartsheet to track all aspects of project development and health. It would be very helpful to have a way of grouping columns. The hierarchy for rows works great, but I think with columns I am just looking for a way to clean up my views. I feel like the best (and only) solution right now…
-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
