-
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!…
-
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…
-
[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…
-
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…
-
[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…
-
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…
-
Why are my Task Rows expanded every morning?
I've been using smartsheet for a few years now and never had this issue before, but starting this year, every morning when I go into one of my project sheets at the start of my work day they are ALL expanded. I have parent and child tasks that are 100% completed a year ago that are now suddenly expanded every morning. So…
-
Formula for Cross-Sheet References Based on Row/Task Information
Is there a way [in the Core App - without Control Center] to create a formula that pulls in data from another sheet via cell linking, but is set up in a way that it can be used in a repeated use template? To give an example of what I'm trying to do: I have a set of projects that are fairly consistent as far as activities.…
-
Formula to count unique cells, no duplicates, AND total only by an identifier
Hi all, I have three columns. One column has a program name (identifier) One column has an identification number (100020000) One column has a time span (spring, summer, fall, winter) I only want to count the identification number once and attribute it to the program name, so I am trying to work out a formula:…
-
Identifying oldest entry on sheet, for different groups
Hello! I am working on a "waitlist" process, where the sheet will have multiple candidates under each work location. I need a formula to identify the oldest entry for each location, and if there are multiple entries for the earliest date, use a "score" column identify the higher score as the next candidate in line. Example…
-
Formula in form-populated sheet stopped working
I created a UTM-generator for website URLs using the "AI" functionality in Smartsheet. I'm not going to bother pasting in the formula here because it was generated by Smartsheet based on the need to basically join column values with strings between each cell value. It has been working fine, and there's nothing that can…
-
How to set up columns to track status by week and not erase when moving to next week?
I have a project with tasks organized by rows. There is a column for status of each task. I've created columns for each week progressing into the future where I want to log the status at the end of each week in each column. My issue is that once we are in a new week, it leaves the previous column (week) blank. How do I…
-
Copy and Paste Column's
Need a way to copy and paste columns from one "standard columns" sheet to new sheets. This would be similar to a template but more flexible.
-
Restriction for email entered into form
We are trying to update a field on our form, where the submitter enters their email. Recently someone entered their personal email, which we do not want. We are trying to update this field so that it will only accept emails with our work domain. Is this possible? I believe it should be but am having difficulty figuring it…
-
New to Smartsheet
Hello! I am new to Smartsheet. I signed up because of a template I saw on the website. However, I can't seem to find the same template. Do you have any advice on how to find this template? Thanks!
-
Automation Notification -- How long does it take?
We are using SS to record events as they happen at our resort. There are certain events that we want to make notifications to key players who may not be monitoring the radio. I have set up a "when triggered" notify these people . This seems to work ok, we are sending a generic message with some of the fields to their text,…
