-
November Question of the Month - Join the conversation and receive a badge [+bonus badge!]
Hello, hello. October’s question had a very clear trend — the Community members don’t fear challenges, change, feedback, or failure, because these are great ways to learn, get creative, and grow. Love that mindset! Who's ready for a new question, and a chance to earn badges and points while getting to know your peers? Read…
-
[NEW] Project Management Certification Practice Exam
Hello Community, Planning to take the Project Management certification exam? We’ve got exactly what you need! Smartsheet University has just released a new FREE Project Management certification practice exam. This is the perfect opportunity to gauge your knowledge, boost your confidence, and get a clearer picture of what…
-
Community Corner Newsletter [November 2024]
Hi hi Community, Rebeca here with all the ENGAGE highlights, and news you won’t want to miss. But first — if you visited the Community booth at ENGAGE, thank you! It was a joy meeting you in person, chatting about all things Smartsheet, and seeing you ace the Scavenger Hunt. 😁 Before we dive in, shout out to @Genevieve P.…
-
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…
-
[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…
-
File library for workspaces now generally available!
Hi Community, We are excited to announce that file library for workspaces is now available! File library brings files into the context of work, making it simpler to find, reference, and collaborate on relevant content from anywhere, at any time. Designed to integrate with your work in Smartsheet, file library allows you to…
-
Meet Jason Tarpinian, our October Member Spotlight! 🎉
4, 6, 8, 10, let’s go @Jason Tarpinian! We’re so happy to feature this Community Champion as our October Member Spotlight. Jason is a Project Manager of Technology at Sevan Multi-Site Solutions, and calls Minnesota home. About seven years ago, as an Assistant Project Manager, he first used Smartsheet to manage hundreds of…
-
Upcoming Smartsheet User Groups - Sign up today!
📢 Attention Smartsheet Community members - We're excited to invite you to join us at our upcoming in-person and virtual User Groups! These sessions offer you a chance to network with other Smartsheet users, learn from their journeys, and acquire helpful strategies for getting the most out of the platform. Best of all,…
-
New Dynamic View and Data Shuttle pricing changes now reflected in Plan Insights
Hi Community, On August 15, 2024, Smartsheet rolled out Data Shuttle and Dynamic View pricing changes to better align with the User Subscription Model. The metrics reflecting this new pricing have now been updated in the Plan Insights page: The Dynamic View pricing metric changed from tracking the number of ‘'Active views”…
-
October Question of the Month - Join the conversation and receive a badge
During September, you shared when and where your mind works best. Of course you all had unique preferences — early birds, night owls, the office, home, white noise, mowing the yard — but you also had quite a bit in common. So many of you get your best ideas while being active, in the shower, or after a nice cup of coffee.…
-
Shift Cell Content
Hello, I'm trying to create a helper sheet that takes status updates for a specific project (abc123) and organizes it uniformly into a single set of columns. Currently I have to manually cut and paste all entries from the Project 2 columns and Project 3 columns into Project 1 columns. There will only be one entry per…
-
Matching 2 Criteria in Source sheet to reference 2 other Criteria in Target Sheet
Hi, I'm trying to use 2 variable data points in a Target sheet to pull 1 data point from the Source sheet that shares the same Criteria and just got stuck, don't regularly use INDEX formula and looking for help - hope the below is detailed enough: Source Sheet: Source Sheet has a a "Supplier" column and "HV Breaker…
-
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…
-
How to connect sheet to multiple datatables
I need to consolidate information from multiple excel sheets (over 100k lines per excel) via datatables to one sheet. Can you please help me how to achieve that? You can have only one connection to sheet, which I don't understand. I can't continue using Smartsheet without this function. Thanks for help and support
-
I need a formula to create a Contract iD for 4 different org's that are listed in 1 column
I need to create a formula in a column that will in the end give me something like ATF021 or RDI231 or RD473 Each org, ATF, RDI and RD will have their own contract iD; so ATF021's next line item needs to be ATF022, 023. Then if the RDI org enters a line item, there contract iD will be RDI231, RDI232, RDI233 and so on. Same…
-
Sorting
Hi Smartsheet Community! I have published sheets (roughly 500 sheets) and the end users are telling they no longer have the ability to sort a column. The end users do not have a license. In the past, they had this ability. Anyone explain what might be going on? Did Smartsheet make a change that I'm not remembering? Thank…
-
Using DISTINCT function
I am trying to use the distinct function. It seems like it should be relatively simple, but I am getting an error message. Am I doing something wrong? Thanks
-
Dynamic View - Download All Attachments at Once
Hi, We need a way to download all attachments in a Dynamic View at one time (vs having to download them one by one). This is an available feature in the regular sheets. How do we do this in dynamic view? thx
-
Automation workflows that were working are no longer emailing gmail and msn addresses
Our existing workflows that trigger automated email alerts have started failing. It started in the last day and only affects gmail and msn addresses from a contact column. The failure message is, "Due to a recent automation permission or sharing change, the following people aren't receiving alerts from your workflow".…
-
needing Index / Match formula help, If cell matches cell in another sheet, return value from
Needing to populate SAP Item # is BPX MM# matches on another sheet.