-
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!…
-
[Virtual event] Jumpstart 2025 with Community is here! 🎆
PLEASE READ: The first showing (9am US PST) is now at capacity! Please register for the second showing at 4pm US PST for your best chance to get in. Thank you. —Our annual FREE virtual event is back! For the third year in a row, you are invited to Jumpstart 2025 with Community on January 23, 2025. We heard your feedback…
-
Jumpstart 2025 is filling up quickly — request an invite!
Hey Community, you are incredible! We’re delighted to see so many of you have registered to attend our Jumpstart 2025 virtual party. Your enthusiasm has been through the roof, and the first showing at 9am PST is FULL. But fear not, if you have not yet registered, you can still request an invite for our 4pm PST showing by…
-
Community Corner Newsletter [January 2025]
Hi everyone and happy 2025! Arsineh here from the Community team bringing you the first Community Corner Newsletter for the year. We had so much to celebrate in 2024 from launching 6 new global languages on Community, introducing AI tools, new views and much more. Check out the December newsletter by @Georgie if you missed…
-
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…
-
Keep unlocking possibilities with Smartsheet AI tools
Hello Community, We are happy that so many of you tried Smartsheet AI tools during the promo time, and had great things to say about them. Learn how other customers benefited from our AI tools here, and get inspired by their stories! Loved Smartsheet AI tools, and what to continue unlocking possibilities with them? You can…
-
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…
-
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…
-
[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…
-
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…
-
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.
-
Archiving Rule in Control Center Not Working As Expected
I have several completed projects located in an intake sheet that I would like to archive. I created an archive rule for projects with a status of "Ready to Archive" to move to a separate workspace. I also checked other freeze & disable features for items. When I tested one project, the only thing that worked correctly was…
-
HELP!! Needing to subtract just one from this formula
I have this formula for a total count! I just need to subtract 1 from the formula This is what I have and it is showing Unparseable ="2021-2022 Total Contracts: " + COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2022, 12, 31)))-1)
-
Count the total # cells with a specific word in a filtered column?
I have a COUNTIF but it is retruning a value that represents the entire sheet and not just the number of cells on the filtered sheet. Is it possible to restrict the formula to the filtered sheet only?
-
Hello! I am trying to make a graph with these dates!
I am using a Grid Sheet and a reference sheet but can not figure out how to get the formula to match. I am using =COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2021, 12, 31))) This is my reference sheet formula =COUNTIFS({OnBoarding Partner Agreements Range 1} [Start Date]:[Start Date],…
-
How do I add a date range formula to an existing formula?
This is the formula I have built so far: =COUNTIFS({EP DAR Data Input Tracker - Sheet (with Fo Range 1}, {EP DAR Data Input Tracker - Sheet (with Fo Range 2}) & "," AND({EP DAR Data Input Tracker - Sheet (with Fo Range 4}, ">=2025-01-01",{EP DAR Data Input Tracker - Sheet (with Fo Range 4}, "<=2025-31-01")
-
Is there a formula to update the status based off the % complete?
i.e % Complete is = to 0% then Status should equal not started, if % complete is > 0%, then status should be In Progress, if % complete is = to 100% then the status should equal Complete
-
Help Article updates
Hello Community, We’ve published the following new content: Using helper columns in Smartsheet Control Center: Troubleshooting FAQ To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at the end of each article.
-
SmartSheet new user subscription model (USM) - provisional status
Currently, there is no notification / pop up / label / status etc, for an end user to know and realize that they become a provisional status user type (and will be either upgrade to Member or downgrade to Viewer at the next true-up / reconciliation) This indication is essential and important, as the end user should know…
-
Adding or changing phases in Smartsheets that live in Resource Management
Can I build, add, edit phases in Resource Management by way of a Smartsheet sheet? I know I can add phases in Resource Management, but I am trying to manage my projects only in Smartsheet.
