-
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…
-
Support Portal ticket experience!
Hello everyone, I'm new here and have a quick question. For those who haven't purchased a support package, how long does it typically take to get a response to a ticket? I submitted mine a week ago, and it still appears to be unassigned and marked as new. I would appreciate hearing about your experiences. Thanks!
-
Percent column adds two zeros
I have data that is sync'd with another smartsheet that i cannot manipulate. My percent column when I select "%" format, adds two zeros. Instead of 95%, it shows 9500%. How can I correct this within my own sheet so that my calculations are correct. For now in my total column, I've divided by 100, but wondering if there is…
-
Allow ISO 8601 Date format for dates (YYYY-MM-DD hh:mm:ss)
ISO 8601 is an international data standard and a part of two national standards in the United States. "The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred…
-
Dashboard - Labels are wrong
My charts labels are all wrong and i can't figure out how to change the labeling. First the bar chart does not show the "$" like how it is in the Report. Secondly, the label for the other axis is indicating random numbers rather than the text that is in the report column. thank you in advance for your help
-
Date format on dashboards
Although I can specify date format on a sheet in the ISO 8106 format, the date widget on the dashboard will only show the standard U.S. format. Is there a way to get the date on the dashboard to show in ISO 8106 for my European colleagues?
-
Using Count ifs to Check 3 columns and validations for a dashboard.
Using Countifs to Check Origin of error with the reference to the month and validation already provided in the data. Everytime I complete the first criteria the option to select the column from reference sheet gets disabled. Please suggest a workaround.
-
Trying to count total points each specific person chosen
Howdy! I am trying to figure out how I can have a running total (Total Points) of the amount of "Points" each "Name" gets. Keep in mind, the same "Name" can be chosen multiple times. So, I would love for the total to be for that person in that row. 2 Weeks ago, they "Name" got 25 Points, today, the same "Name" received 10…
-
Index/Match Help
Since Excel created XLOOKUP, I have lost my ability to properly do index/Match, I am getting an #INVALID COLUMN VALUE error. First here is my formula: =INDEX({Deliverable Tracker Approved Archive_Delivery Liaison download complete}, MATCH(Help@row, {Deliverable Tracker Approved Archive_Help2}, 0)) This screenshot is from…
-
Count # of cells approaching a date for sheet summary
I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell. This is what I've tried: =COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7) Thank you for any help!
-
Budget Rollup based on used Resources
I currently have this formula for my budget =IF([Resource Helper column]@row > 4, [Quoted labor budget ]@row - (200 * ([Resource Helper column]@row - 4)), [Quoted labor budget ]@row). I want to do a roll up each time an additional resource is added in the child rows and any additional rows for created for each project. Im…
