Best Of

In an effort to manage our teams and to keep their projects grouped together, we have individual workspaces for each department. We want these users to have a license so they can create and manage their projects accordingly; however, we do not want them to have the ability to create ad hoc workspaces that our PMO or management team cannot see. This idea is to provide restriction capabilities that would allow us to restrict or grant the ability for licensed users to create workspaces.

I several reports I've created I need to get an accurate count of checked checkboxes within the summary section of the report, and currently, the summary is counting all checkboxes- whether they are checked or not. The image below shows that it's counting 4 checkboxes, but it should only be three since that's the total that are checked.

What's even more maddening is that when you select a column on the report the count shown in the bottom-right corner IS actually only counting the checked check boxes, so why that's not an option in a report summary is beyond me.

I would love to be able to select multiple tasks on a sheet and change the status if they are all the same. This could affect dropdown columns and date columns.

This is probably a pretty common request but it's frustrating me on a project right now so thought I'd bring it up.

My idea is that Smartsheet make Contact List components accessible via logic and object calls. For instance if:

Smartsheet.Objects.ContactList(Firstname, Lastname, Email)

So if you have a columns containing Firstname, Lastname, and Email individually, you could have a function that builds the contact list field by doing something like =ContactList([Firstname]@row, [Lastname]@row, [Email]@row) thus building a contact from individual parts. That would make using forms to populate contacts much more usable.

Or in something like an update request or alert. Have the ability to pull individual components like:

Hello {{ClientContactCol.Firstname}},

If you have any questions, please contact your attorney at {{AttorneyContactCol.Email}}.

This would be very useful.

Thanks!

When creating a formula you're given the option to "Reference Another Sheet".

I love this feature but it needs improvement because it ONLY gives you the option to create a new reference.

Yes, you can click the same range as an existing range and it will auto-populate with the correct range number, but that's only if you remember the exact range.

What if you changed the options?

Instead of "Reference Another Sheet" give two options:

1. "Create a Reference to Another Sheet" and
2. "Select an existing Sheet Reference"

Example if "Create a Reference to Another Sheet"

Eample if "Select an existing sheet Reference" is selected:

Alternatively, you could keep the same "Reference Another Sheet" option but display the existing sheet references immediately, but also allow the user to browse to the sheet/range they wish to create a new reference from.

PS. The browse window for creating a new sheet reference should always default to the current workspace!

I really miss allowing the user to actively filter information from their dashboard view. I wish I could have a filter button that could be positioned on the dashboard. Then the user could choose to see the data of a period or a project, for example.

I completely agree that this is a very much needed feature. Two major purposes would be served by having an audit trail of actions taken by SmartSheet automation: (1) when developing a new automation, especially one which involves multiple sheets, it would be VERY helpful for troubleshooting, and (2) for those of us accountable for results, having an audit trail is necessary to be able to prove compliance with our processes, and any applicable regulations (or even laws).

Smartsheet doesn't have a way to see if the email was sent, to whom the email was sent and what was the email that has been sent. We can only see when the workflow last run and work on blind faith that it actually was successful. Only to find out weeks later people aren't receiving the alerts, and there isn't a reason why they wouldn't be.