Best Of
Re: Did Shortcut Widget Loose the Ability to link Dashboards?
Hi @Lynn U, @kowal and @celtics345,
I'm jumping in here as I've tested this and it's working on my end. This is also discussed in this related thread: Adding a dashboard link to a different dashboard, where @cg80 has suggested the feature is now working again. It therefore looks like this may have been a temporary issue which is now resolved.
Could you all take a look again and see if you're still experiencing the issue? If you are, I'd recommend submitting a support ticket so the team can investigate.
Thanks!
Georgie
Georgie
Re: Folder-level permissions
While this is now possible with collections this solution isn't viable for many users in solving this problem as it's behind the enterprise paywall. Would be great to still have folder level permissions rolled out for all users in some function
Matthew L
Re: Corresponding with External contacts
Thank you for this!
I was looking more for correspondance just via email. Like is it possible to send an email through a comment, not share the sheet, and they reply to the email Smartsheets send, and that email gets posted in the discussion?
Ability to choose what to display when using contact list in a column
Sometimes would like to just display Initials or just the first Name or just the last name and not the whole name. Would like the flexibility to choose what is displayed.
jax69
Re: Can chat conversation notification be directed to the report rather than the main sheet?
I agree Stacie too much work to try chat with people you only want them to view in a Report. Not sure why they couldn't write code to direct the people to the report where the chat is origininating.
Pam Dunn
Re: COUNTIF Formula for Contact Column
The formula originally given should work
=COUNTIF({Contact},HAS(@cell,[Name(contact)]@row))
Example data:
Cross sheet look up:
If you're trying to do something different to this, let me know as I may have the wrong idea of what you're trying to accomplish!
Nick Korna
Re: How to tirgger multiple different actions in response to a single Automation Trigger?
Thank you Frank. I understand the pattern now. I guess there's a trade-off. Your pattern keeps all of the actions in a single Automation (which is good, and what I was looking for), but introduces some potentially complicated conditional logic/flows. The alternative is two Automations (not ideal), but with a straightforward condition directly on the trigger.
Thank you for the feedback and suggestions.
-tom
Tommi
Re: New streamlined creation experience
I don't get to use Smartsheet as much in my new position, but was a super user in my previous job and am also surprised and disappointed with this 'strategic shift' release. Not every use of Smartsheet needs a workspace. Yes, group work where you can easily share a collection of multiple sheets, reports, dashboards for either targeted project or client is fantastic. But not having the ability to organize my own work and select between my personal sheets and a workspace is frustrating. It is like creating a new folder in a directory every time you create a new Word document. I should be able to default new items to my Sheets folder, like a personal directory, and if I need something new in a specific workspace I will do it there. This is a 'delta' in my opinion.
Rusty314
Re: New streamlined creation experience
Sent in feedback via the attached form on the OP, but want to publicly express my frustration here about this change. Who approved this? Without having a sheet space I am now resigned to create an individual workspace to share individual documents with people. I manage the Smartsheet account for 100 people in our office and share many documents at a singular level outside of our workspaces that are established. This is going to be problematic. I've already had to direct multiple employees to customer service who are having document issues as a result of this change.
Please restore this functionality immediately.
Worst. Change. Ever.
Brian Wilson DC
Re: Sheets to Workspaces - Permission Help
Hi @Jerika
You're not alone—this is a frustrating part of the transition from Sheets > Workspace. Here's what I found from testing and digging into Smartsheet behavior:
- When moving a sheet from the "Sheets" folder into a Workspace, any sheet-level sharing is lost. That means users previously invited to specific sheets no longer have access unless you re-invite them.
- Unfortunately, I couldn't find a way to retrieve share history using the Smartsheet API. Even the
GET Eventsendpoint doesn't track share/unshare actions, which limits auditability. - As it stands, **you’ll need to manually add shares - a chore! - after moving items into a Workspace, especially if each sheet had unique permissions.
- The effort users put into sharing sheets with the right people and right permission levels will be completely lost after the move. What a burden to users!
- Regarding the share history, you can check past activities—including shares—using the Activity Log, but only up to 90 days can be downloaded.
- To help:
- Filter the Activity Log for sharing activity.
- Export to CSV.
- You will get an email.
- Import the CSV
- Extract emails and permissions from the “Details” column using these formulas:
- Email:
=IF(ISTEXT(Details@row), MID(Details@row, FIND(CHAR(40), Details@row) + 1, FIND(CHAR(41), Details@row) - FIND(CHAR(40), Details@row) - 1)) - Permission:
=IF(ISTEXT(Details@row), MID(Details@row, FIND(CHAR(34), Details@row) + 1, FIND("permissions", Details@row) - FIND(CHAR(34), Details@row) - 3))
a-b
c.
d.
The imported sheet looks like this.
e.
In the long term, you could use a helper tool that reads sheet shares, moves sheets to a workspace, and re-applies permissions automatically. Let me know if you’d like help building that kind of tool.
