Best Of
Multi-window support in the desktop app now generally available!
Hi Community,
We're excited to announce that the desktop app now supports multi-window functionality!
Previously, the Smartsheet desktop app could only be opened and viewed in a single window. This was a blocker for many users who liked viewing Smartsheet items in multiple windows or screens/monitors. Now, users can move a Smartsheet item in the desktop app to a new window by right-clicking the tab and selecting the “Move Tab to Another Window” drop-down option. This allows users to easily view their Smartsheet assets on multiple windows, screens, or monitors and increase productivity.
To enjoy the multi-window functionality, please ensure that you're on the latest version of the desktop app (v 1.0.34 as of this release).
Please note: Future enhancements enable users to click, drag, and drop tabs into new or existing windows.
This feature is available to licensed users on all plan types and free trial users in the Commercial US region.
Learn more about the Smartsheet desktop app.
You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Cheers,
Lekshmi Unnithan
Senior Product Marketing Manager
Lekshmi Unnithan
Re: Smartsheet + Generative AI 🖥️
Hi Everyone!
My name is Brian Shin and I recently joined Smartsheet to lead our AI strategy and execution. I have been working as an entrepreneur and investor in the broader Artificial Intelligence market for over 10 years now. I am truly excited by the opportunities that Smartsheet has to innovate for the benefit of our customers.
It was amazing to read through your answers in response to our April Question of the Month “How would you like to see Generative AI applied to help you do more with Smartsheet?” Many of your ideas are not only very thoughtful and exciting, but also line up with our own thinking.
While we cannot disclose details around our plans just yet, please know that our efforts will be consistent with Smartsheet’s reputation for customer empowerment in the most responsible, secure, and privacy-compliant manner possible.
We greatly appreciate your feedback and look forward to sharing more with you soon.
Sincerely,
Brian
brianshin
Report to see if someone is really using their license
Have a report that shows
How often a license user is creating new sheets, adding column, automations, forms. Items that only a licensed user can do. This would help determine if someone really needs a license or if that license is being wasted. Thank you.
Keven
Setup "default" tabs to open within Desktop App
As a power user, I would like to have the ability to have a list of Smartsheet sheets to open as tabs each time I open the desktop app. Favorites are great, but having to manually open up these sheets is honestly a waste of time each day and having a default setup would be far superior.
BBerry
Improved User Auto-Provisioning
It would be great to be able to specify some additional options for user auto-provisioning:
Have the ability to add auto-provisioned users to Groups automatically -
Being able to add new users to an "All Employees" group automatically would mean they could have access to some resources by default. In my case, users automatically having access to our Smartsheet FAQs Dashboard would link them to valuable information, links to Smartsheet Help sites and Community, and easy access to our internal Smartsheet Help Request ticket system.
Set up an automated notification to System Admin or other email address when a new user in our domain creates their Smartsheet account and is provisioned -
This would allow us to pro-actively take other specific actions for that user depending on their role/department/job function - giving them access to workspaces, sending them documentation, adding them to department-specific groups, etc. - instead of waiting for their manager to have to ask.
Jeff Reisman
Desktop App - Group Tabs
I'm loving the Desktop App, however, it really needs the ability to group tabs or otherwise keep all my tabs organized. Please add this functionality!
Brian R
Rich Text Formatting in email notifications (and Update Requests)
Hi,
unfortunately I heard from Andree that is still not possible to
format text in update requests or email notifications f.e. bold, italic, underlined as well as putting URL-links to certain words or make quotations.
I regret this because I find it a very important function and hope you will agree and find a solution.
Hope to hear from you, soon. Thank you.
Jörg Schmidt1
Copy Specific Columns From One Sheet to Another, Linked
Add the ability to specify the columns to copy and link from one sheet to another in the Copy Row automation.
SMullen
Re: Consolidate unique values from multiple columns into single column
I turned off the publishing because there was another more efficient solution presented by someone else that uses the SUBSTITUTE function and adjusting the placement of the SUBSTITUTE to essentially place a locator. I must have forgotten to include a link to that thread when I did that. I can't remember who posted it though, but I have tweaked it a bit.
First you will need a text number column (called "Number" in this example). In this column you would manually enter the numbers 1 through however many you will need.
Then in the column you want to parse the list down, you would use something like this:
NOTE: This is under the assumption that you will not have ! (exclamation point) or | (pipe) in any of the data you are wanting to pull through. If you are, then you will need to use different punctuation in the formula. This is also assuming that the list you want to remove duplicates from is all in a single column. You may need to adjust the List:List range if you are pulling from multiple columns.
=IFERROR(MID("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!", "|", [email protected])) + 1, FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!", "|", [email protected] + 1)) - (FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!", "|", [email protected])) + 1)), "")
Formula is in [Column2] of the below snippet:
Paul Newcome
Re: Manage personal and work data across two Smartsheet accounts in a unified, secure way
This is great!
Meal planning is an important strategy for keeping my home life organized, but I dread it. Scrolling through my bookmarked recipes, digging through print recipes, trying to come up with ideas... just dreadful. Recently I had an aha moment - what if I used Smartsheet to create a 10-week meal plan?
I printed my online recipes and ripped my favorites out of recipe books, put them in a pile, and numbered them all sequentially. I then made a Smartsheet to track them all, added some categories, and created checkbox columns for each week. I just randomly went through and selected 5 recipes for each week, and created a report for each week. When that weeks rolls around, I can make changes and select additional recipes using filters. If I want to find a vegetarian Italian meal that will have leftovers, I don't have to dig through recipes to find it.
When the evening rolls around, I just look at my report for the week, find the recipe number, and dig it out of the stack.
Here's what's on the menu for this week. Bonus Tip: Some of our favorite recipes are from Star Wars cookbooks. 😆
I also use Smartsheet to spot trends in how exercise, sleep, work location, amount of social interaction, and other things affect my energy level and motivation. I send myself an update request every day at 5pm to rate different categories. To my surprise, so far exercise seems to have a bigger impact on my energy and motivation than sleep.
I would love to see others' ideas! I bet @Alison Clancy has some!
Julie Fortney
