-
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…
-
Is it Possible to change what columns are shown when you click in on Card View
Hi All! :) I have a report which connects to other SmartSheets, and is primialry viewed and updated via Card View. However, when you "click in" a card, it shows all the columns of the source sheet, including those which are hidden. Is it possible to change this? I have attached a Snippy for reference. I am looking to…
-
Partially "Color" and "highlight" context in one cell
-
Average of figures in a cell range when the cells are a formula to calculate days past
Is there a formula to calculate the average when the cells in a range contain numbers? The cells contain a formula to calculate the number of days from one date to another, but I want the running average while entries within that range are populated over time, ie I don't want to have to readjust the formula when a line is…
-
Combine Multiple IF statements
Hi! I am trying to write a formula that returns "Yes" when all expressions are true. I have written four IF formulas, that work independently but cannot figure out how to combine them. My final formula will not move past the first expression. Here are my criteria: IF Procurable is Yes, TBD, or Blank =IF(OR([Procurable]@row…
-
What's your Best Error Checking Column Using Formula?
I have discovered multiple ways to create a error checking column that looks in all columns to see if there's a broken formula somewhere. However, all the ways I have found aren't very elegant and don't provide the type of details I want. Example: =IF(ISERROR([First Column in Sheet]@row:[Last Column in Sheet]@row), 1) This…
-
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)
-
IF & ISBLANK with two Criteria in separate columns
Good Evening, I need help fixing the formula below, I need the checkbox to be empty if it is able to locate an entry when the month of January (in column named 'Please select the reporting month.') and the year 2025 (in column named 'Select the reporting year.') is selected from sheet named 'Section & Chapter Reporting…
-
Does the dynamic view work with formulas?
I have one of my sheets set up so the program chosen references another sheet and generates a contact. I have created a dynamic view to restrict the view so only the contacts of those programs can see and edit their data. Unfortunately, it's not working. Is this because a formula with cross sheet references generates the…
-
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…
