-
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…
-
May Question of the Month 💭 Join the conversation and receive a badge
Hi everyone, We recently shared a Forbes article from our EVP of engineering, Praerit Garg that spoke about the big impact managers have on the performance and retention of their teams. In keeping with the topic of career impact, this month's Question of the Month asks: Who has had the biggest impact on your career and…
-
Manage personal and work data across two Smartsheet accounts in a unified, secure way
At our senior exec meeting last week, we were discussing things from our personal lives that we manage in Smartsheet. We spend so much time talking about how customers use Smartsheet to power processes, that it was a fun change of pace to talk shop about life hacks -- also powered by Smartsheet. I’m posting to the…
-
Smartsheet EVP of engineering, Praerit Garg discusses the importance of middle managers
Hello Smartsheet Community, In a recent article for Forbes, Praerit Garg, Smartsheet EVP of engineering shares insights on transforming middle management and amplifying the power of people. He highlights the importance of great managers, noting that they “drive employee engagement, retention and performance”. He points to…
-
Meet Melissa Boehl, our April Member Spotlight! 🎉
Our Member Spotlight this month is none other than @Melissa Boehl! A Community Champion from North Carolina, Melissa works as a Business Systems Analyst at WithersRavenel and is a self-proclaimed "Smartsheet nerd." (Alison note: Relatable). "Smartsheet has been my go-to tool," she says. "The platform has empowered our…
-
Smartsheet Integration for Microsoft Teams apps consolidated and permissions reduced!
Hi Community, Previously, Smartsheet had two Microsoft Teams applications that serviced three different capabilities, required separate admin consent flows, and requested excessive permissions: The Smartsheet app (supports the ability to send notifications and search for Smartsheet items within Teams) The Smartsheet Tabs…
-
Smartsheet + Generative AI 🖥️
Hi there, With new generative technology like ChatPT and DALL-E making recent headlines, we've seen a growth in curiosity and interest around what this means for each of us in the way we engage with the world, the work we do, and how we collaborate with one another. Ben Canning, Senior Vice President of Product at…
-
Hot off the presses: Community Corner Newsletter! [May 2023]
Hi Smartsheet Community! I’m Max on the Community team. Thank you so much for all the wonderful comments and reactions to our first edition of the Community Corner - Alison did an amazing job of bringing it to life. As a result, you can expect this newsletter every two months! Let’s get into what has been happening in the…
-
📣 New this Quarter - Innovations to help you manage marketing, content, and people
Hi there, Our product team has a ton in store this quarter and we're thrilled to be sharing a preview of what's to come. This quarter’s innovations will be focused on helping you manage marketing and creative work, content and people to deliver better on-brand customer experiences at scale. Ben Canning, SVP of Product…
-
Welcome internationally acclaimed photographer Matika Wilbur to the Smartsheet Community 👋
Hello Community, We’re thrilled to introduce you to internationally acclaimed photographer and Project 562 founder, Matika Wilbur from the Swinomish and Tulalip Peoples. Matika’s the first artist-in-residence for The First Residence — the first-ever artist residency hosted by the Seattle Kraken and Climate Pledge Arena.…
-
Report with just 2 rows needed
Hello, I need to create a report that shows me "installation complete" from around 88 pages, I tried so many different things, but I can't get to do it. It keeps showing me rows that I don't need. If you know, please help. Please see below; if you can see, it shows the site audit, but I need the "Installation crew…
-
Can you save/archive sheets?
I conduct various audits, traceability exercises, mock recalls, etc.. Upon completion can these be automatically saved to a file for review and compliancy verification for 3rd party auditors? Thank You. Blake
-
Horizontal Axis
Hello, I am hoping that there is a way to rename the horizontal Axis with grids rather then having to keep making a metric longer and longer. This is where the information is being pulled from. But, when I create a dashboard you will see that it is not being labeled with the months. Making my metric sheet and this…
-
Auto-Number Not Working
I have an Auto-Number function running in one column and after number 1966, I added information in the next row, and it spit out the number 1997. I then deleted the information in the row and then added it again and now its 1998. I added another row after and its 1999. I need the next row to be 1967. Any suggestions…
-
Formula to calculate working hours
Hello Team , Please see attached photo above Im looking for away to count my employees daily working hours (in working hrs col) The Col names ( Shift Start and Shift End) are select down menu for 24/hrs (hrs and minutes separated with colons) I Need a formula for column (Working/hrs) that count the number of employee's…
-
Search for specific words within texts
Hello community, I would like to know if within the smartsheet there is any way to search cells through specific words, using a count formula for example. Within Excel we use * to search for a word that is together with others. Example: =COUNT.SES($C$31:$C$67;"Day by day*";$D$31:$D$67;E280) This formula brings the count of…
-
Can you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
How do I extract full URL from Hyperlink cell?
Hi all I have this Opportunity ID column in my sheet that's connected to Salesforce. All cells are hyperlinked with the opportunity in Salesforce. This column is created like this by the Salesforce-Smartsheet connector and it's handy because of the hyperlink. I need to send the Salesforce URL to another sheet, but if I…
-
Upload Thousands of Excel Documents to Rows
I have been building a workspace for inspection tracking. Before this we were utilizing an Excel doc that would use a macro to create a new Excel doc for each inspection with the information that was entered. There are 2332 excel documents. The information in each doc are not in individual columns. The filenames are Asset#…
-
How to interchange one cell value with another cell value in the same sheet.
I have 2 sheets 1st is Asset Master sheet and 2nd is Material Movement sheet. Once I received a new cell value from Current Location Final which is populated from Material Movement sheet. I want to interchange the cell value in "Current location Final" to "Current location" in Asset Master sheet. For e.g. After using the…