-
January Question of the Month - Join the conversation and receive a badge
Hey there Community, I’m so happy to start 2025 with all of you. Be that you’ve been here for a long time (anyone close to 10 years?), or just joined today — thank you for being a part of the Smartsheet Community. If you’re looking for a chance to earn badges, and getting to know your peers, you’re in the right place!…
-
Discover how others are benefiting from Smartsheet AI
Hey Community, Are you curious about AI, but haven’t tried it yet? Your peers in Community have been exploring its potential. Now, we’re sharing their best insights with you. Discover what they had to say, and get inspired by all the ways they are leveraging Smartsheet AI to innovate and save time. The Community explores…
-
[RECAP] Sarah Valente: Marketing Creative Institutions
Hello Community! So excited to share this new episode of the Brand Collective podcast, featuring one of our very own Smartsheet Overachievers @Sarah Val Valente from Berklee College of Music. 🤩 If you’re into the arts, project management, education sector, or even guerilla gardening, this episode is for you! Here’s a sneak…
-
What view are you? Share your story and claim your badge
Hello Smartsheet Community, We love reading stories about the meaningful change you’re driving at work. Everyone has their own way of managing work, right? That's why we've ensured you always have a Smartsheet view that fits your needs. We want to hear how you are using Smartsheet and how it may change depending on the…
-
Solution Spotlight (HLS)- Dynamic View for Insurance Verification & Accreditation Processes
Hello all! On Tuesday, 1/7/25 at 11:30am PST/2:30 EST the Healthcare & Life Science (HLS) Solution Engineers are putting on a Solution Spotlight Demonstration of two unique solutions utilizing Dynamic View to securely control data. The registration dashboard is here (no account required, and even if you can't attend we…
-
Smartsheet has been recognized as a Leader in the 2024 Gartner Magic Quadrant for Collaborative Work
Hello Community, Did you hear the great news? Gartner recognized Smartsheet as a Leader in the 2024 Magic Quadrant! Not only was Smartsheet recognized as a Leader in Collaborative Work Management for the second year in a row, but we were also recognized with a Gartner Peer Insights ™ ‘Customers’ Choice’ distinction for…
-
Notifications to Microsoft Teams Channels in Gov is now available in Smartsheet Gov!
Hi Community, We're bringing Microsoft Teams to Smartsheet Gov! We are making notifications to Teams Channels available on the platform for the Gov Community Cloud. This will empower our Smartsheet Gov users at most civilian federal agencies and state and local government institutions to start transforming conversations…
-
Meet Amit Wadhwani, our December Member Spotlight! 🎉
It’s the holiday season, and we’re featuring a very special Community member to help us end the year: @Amit Wadhwani, Community Champion and our December Member Spotlight! Amit is the Vice President of Operations at Ignatiuz, Inc. and lives in Pennsylvania in the US. In 2017, his manager at the time asked him to look for…
-
Phase integration between Smartsheet and Resource Management now generally available!
Hi Community, We’re thrilled to announce a new feature that integrates project phases between Smartsheet and Resource Management, creating a more unified and seamless experience. With this update, you can now set up a phase column in Smartsheet and sync phases like Initiation, Planning, and Execution directly to Resource…
-
Help Article updates
Hello Community, We’ve published the following new content: Smartsheet Control Center: Program reports Admin Center: Configure IdP-managed access Admin Center: Manage IdP role-based groups Prepare your IdP for IdP role-based groups Admin Center: Change a user's primary email address System Admin guide for migration to the…
-
Using the same form on a different sheet.
I have a sheet that populates with information from the form that is attached to it. I want to create a new sheet for 2025 but have the same form and same form link on the new sheet so that I don't have to send out a new form link to everyone. How do I do this?
-
Creating a weighted scoring system using data entered on a form
I am creating a scoring system to review customer service contacts that I want to be able add weighted scoring to. I have five key categories that I want to account for 20% of the total each, and within those categories, 2-4 categories where a rating of "Achieved" "Partially Achieved" or "Not Achieved" will be assigned. I…
-
Am I able to create a formula that will advance the percentage complete based on start and End Date?
I am looking to automatically advance the Percentage complete calculated against the Start and End date with today's date as a variable. Is it possible to Calculate Duration (3Days) and use the first day as the criteria to automatically reflect 30% complete based on the start date?
-
Delete Rows using an Automation
Please create automation to delete Rows. Using the move rows automation, we are able to move records to an archive sheet. The problem then becomes we have to manually delete records from the archive sheet.
-
#Invalid Operation
I am getting an Invalid Operation error. The cell has the same EXACT formula as multiple other cells and I have checked the cells from which the calculation is being made. All are good. I had this happen twice. The first one I simply went to a new row for all the calculations and the formula worked in the new cell. Is this…
-
Within the last 12 months
I can't get my formula to pull violations reported only within the last 12 months. Can someone see what I am missing? =COUNTIFS({Compliance Master File V2 EE-number}, [EE Number]@row, {Compliance Master File - Compliance Category}, "Reinstatement"), AND({Compliance Master File V2 Violation Date}<=[Today]@row, @{Compliance…
-
Introduce yourself & get to know your peers!
Hi there, Get to know other members in the Community and take a minute to introduce yourself in the comments below. Feeling at a loss for words and need a little inspiration? Tell us where you’re from, your role, how you use or hope to use Smartsheet and a fun fact or two about yourself. (We love to learn about your…
-
[RECAP] Driving change at ENGAGE Seattle 2024
Ready to relive the brilliant ENGAGE Seattle week? Read on for all the highlights, (and some very nice photos) to make you feel like you’re back at ENGAGE all over again. Overachievers and Champions So many of the Overachievers and Community Champions were present at ENGAGE, and their energy was felt throughout the entire…
-
Export the board view
Hi, I'm trying to export the Board view but I can't find the menu barto do it. If you can help me please. Thank you!
-
Pull out latest data from 2 different worksheet
Hi, Happy new year everyone! Im just wondering if it is possible to get the latest data from certain column, using max collect, my goal is to scan the 2 different sheet then get the latest data (SI No. Column) using the date of deposit column and Account column as reference Please i need help.
