-
Meet Monique Odom, our April Member Spotlight! 🎉
Let’s get loud for @Monique_Odom_Comcast, our April Member Spotlight and Smartsheet Community Champion! Monique is a Business Process Excellence Manager at Comcast and calls Pennsylvania home. At a previous company, the fateful day came when she was asked to manage a platform she had never heard of before - something…
-
May Question of the Month - Join the conversation and receive a badge
Last month, we asked you to share something you would try if you knew you couldn’t fail, and the responses showcased the beautiful diversity of our Community. As some of you pointed out, failure is an important part of learning and improving, but it’s still amazing to know what you would pursue if that wasn’t a concern. I…
-
The paradox of governing user autonomy
Hello Community, In the world of hybrid work and AI’s promises to transform the workplace, IT departments find themselves in the seemingly paradoxical position of expanding access to information while also protecting it from ever-evolving threats. Chris Peake, Smartsheet’s CISO & SVP, Information Security, shares how we…
-
Be aware of upcoming changes to your Smartsheet login options
Hi Community, Studies have consistently highlighted the vulnerabilities of password-based systems, including susceptibility to brute force attacks, phishing, and password theft. Such risks not only jeopardize data integrity but can lead to severe repercussions. As a part of our ongoing commitment to enhancing the security…
-
Community Corner Newsletter [May 2024]
Hello everyone! It’s Arsineh from the Smartsheet Community team. It’s been an active month on Community and there’s so much I’m excited to share with you. In case you missed it, check out the April Newsletter by Rebeca to discover some newly introduced Smartsheet badges and topics and get a peek at Rebeca’s beautiful…
-
Welcome to the Government Community!
Hello! This is a space for Smartsheet and Smartsheet Gov users that work in all levels of government to connect, share ideas, challenges, best practices and how you are using Smartsheet and Smartsheet Gov to create impact. My name is Chris, I lead marketing for the Smartsheet Gov platform and am excited to get to know you…
-
Are you attending Smartsheet Gov Forum?
Are you attending Smartsheet Gov Forum, the inaugural customer event for users of the Smartsheet Gov platform? Let us know! Introduce yourselves and get a head start on your engagement and networking! Not registered yet? Sign up while there’s still space available to come sharpen your skill set, deep dive into the…
-
Smartsheet named Community of the Year!
Hello, I’m happy to share that our Smartsheet Community has been named Community of the Year in the Super Forum Customer Awards 2024. Super Forum 2024 marks the 14th year of this annual conference by Higher Logic hosted in National Harbor, MD. With Higher Logic representing over 350K online communities – this recognition…
-
Nominate Peak Humans & get a badge!
Hi Smartsheet Community, We loved learning about what operating at your peak looks like for you, and now, we want to give you the opportunity to recognize and celebrate others, and earn cool badges as you do it 😉 The Operate at Peak Human campaign is a celebration of humanity. Recognize someone who does a great job in any…
-
Get help right away with the Premium Support Package
Hi Community, Looking for help with your Smartsheet and want it right away? We’ve got you covered. The new Smartsheet Premium Support Package is an improved enterprise grade support experience for customers that need prioritized support. Formally known as the Professional Support Package (Pro Support), the Premium Support…
-
Allow Primary Column to be moved in Reports while using Grouping
When grouping data on a report, the primary column becomes locked in the first column position. This becomes a problem when trying to utilize the "Use first column as series labels" option on the Chart Widget in Dashboards. I want to group data by week in my report, and have the week appear as the labels on the x-axis of…
-
View Data Shuttle Status on Dashboards
Is there a way to display current Data Shuttle status and the last time a workflow ran on a dashboard? I'm frequently having to check Data Shuttle to see when a workflow ran last, and it would be useful to have this available via a report, widget, or embeddable content.
-
How to capture Submitters name if not logged in?
We are trying to create a form and capture the submitter's name automatically. We used 'Created by' but when I send a test form, the name displays as web-form@smartsheet.com and not my name, I am logged into Smartsheet when doing this as per several suggestions. Our main issue is most of the staff filling out this form…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
#BLOCKED Error with COUNTIFS when Range columns are populated via equations
Hi, I am trying to calculate the amount of "Used Inventory" by counting the number of times "Block Date" appears between "DATE 1" and "DATE 9" but am getting the #BLOCKED error. Columns "DATE 1" through "DATE 9" are populated by equations based on "CheckIn Date" and "CheckOut Date." Below, you can see the columns in use…
-
Help with COUNTIFS formula
Hello! I have a sheet that lists grant applications. Each row is a different application, and contains information about application due date (formatted as Date), application status (a drop down list), and many other things. I'd like to be able to automatically report on the number of in progress, pending, awarded, and…
-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
-
How to move certain columns only from one master sheet to another sheet
Hi I have a master sheet - being updated regularly through forms and status changes, How can I move some of its columns in another sheet, and use those columns as dropdown in forms to create further workflow.
-
Rank duplicates oldest to newest
Hi Team, I have searched previous posts but can't get a formula that works. I have multiple sheets copying to a master sheet. I need a formula that ranks the row IDs from newest to oldest. This formula then marks a checkbox, which triggers an automation that moves duplicate rows. Checkbox formula and automation is sorted.…
-
Formula to return User Name from Created By
Is there a formula to return User Name from Created By?