-
December Question of the Month - Join the conversation and receive a badge
During November, we had a great conversation about AI, and how it's helping you to work smarter, not harder. We loved reading how you use it with your formulas, to analyze data, onboard new users, or even as a trainer to improve your skills faster. We also received excellent video responses, and you’ll see a selection of…
-
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…
-
Join us for a Accreditation Survey Prep & Survey Tools Community Call - Dec. 5 @1:30pm EST
Missing the excitement from Smartsheet Engage? We are too! Let’s keep the momentum going! Join us on December 5, 2024, from 1:30–3:00 PM EST / 10:30–12:00 PM PST for an exclusive Community Call featuring Regina Shelnutt, Accreditation Manager at Tanner Health. Regina will showcase her innovative Smartsheet solution for…
-
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…
-
Community Corner Newsletter [December 2024]
Hey everyone! It’s my first time introducing the monthly newsletter - if you haven’t met me or seen my name here in the Community yet, hello!! I’m Georgie, and I joined the Community team in October. I’m so happy to be here and love seeing how all you fabulous members help each other out every day! Before we get started, a…
-
Restrictions to primary email changes, now generally available
Hi Community, We're enhancing security by restricting end users from changing their primary email address in the Manage Email Addresses UI under Personal Settings → Profile. Now, only System Administrators can modify a user's primary email address via the User Management UI in the Admin Center, and this will be limited to…
-
How to celebrate Giving Tuesday 2024 with the Smartsheet ERGs
Hey Community, I've had the privilege of getting to know quite a few of you this year, and we have some really smart, talented, and generous people around these parts. The holiday season is a time to give back, and each year on Giving Tuesday, our Smartsheet Employee Resource Groups (ERGs) carefully select nonprofits that…
-
Meet Jacob Stey, our November Member Spotlight! 🎉
Come say “hey” to Jacob Stey (@SteyJ) because he’s our November Member Spotlight! 👋🏻 You may have seen this Community Champion at ENGAGE Seattle or helping others around the platform - now’s your chance to hear his “Smartsheet Story” straight from the source. Jacob is a System Administrator at Patriot Group International…
-
Discover how others are benefiting from Smartsheet AI
Hey Community, Are you curious about AI, but haven’t tried it yet? Smartsheet AI tools are open to all customers until December 31, and 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…
-
Community Champion class inductions are underway! 🏆
Hey Community, I'm excited to tell you that we're working on inducting the next class of Community Champions! (Pictured from left to right: @Jake Gustafson, @Peggy Parchert, @Mark Safran, @Paul Newcome, @SteyJ, @Jason Tarpinian, and Champion turned Overachiever @Lauren Dominique) If you're brand new to Community, our…
-
Creating daily work schedule for individual team members (from a master project grid).
Hello, I'm building a system in Smartsheet to manage work requests across all projects in my organization. The basic idea is for Project Managers to submit task orders to a common grid, which are then assigned to various team members. Ultimately, this new system will serve as the primary work scheduling tool. The system is…
-
Is it expected behavior for "Blueprint Summary" Cell Links from an "Optional" template not to work?
Using Control Center, I am adding an "optional" sheet from the blueprint templates to some existing projects. While Control Center is then linking the identified "Blueprint Summary" fields from the newly added sheet to our metrics Rollup sheet….they don't actually function. Meaning they show a blue arrow as if they are…
-
Link to sheet in Automation, no longer working
I have recently been alerted that the Link to the Sheet that was sent via an automated Alert email, no longer works. Has this function been removed? No other changes have been made to the Alert. Interestingly the links work when accessed via the Smartsheet notification section. I have attached two Snapshots showing the…
-
Barcode Scanning
I want my supervisors to be able to open a form, scan a barcode and have the number associated with that bar code populate in a cell. Is this possible and if so how would one go about implementing that?
-
Subtraction formula with conditional IF statement from cells populated from index match
Hi everyone, I'm trying to create an inventory spreadsheet that auto calculates the QTY in the warehouse by subtracting the amount received from the amount signed out. These columns are populated via an index match formula cross referencing another sheet. I also need there to be the caveat that if nothing has been signed…
-
Upload -Data Shuttle
I have follow all the step in setting up the data shuttle upload and do only for 1 mapping buts when I want to Name the workflow it give the error-One or more of your sheet columns names are using the same name. Update the sheet columns in the mapping to only use unique names.
-
Python API SDK SSL: CERTIFICATE_VERIFY_FAILED Error
I am running into this error trying to connect smartsheet api via python sdk and getting this error on a mac book pro: smartsheet.exceptions.HttpError: (SSLError(MaxRetryError("HTTPSConnectionPool(host='api.smartsheet.com', port=443): Max retries exceeded with url: /2.0/sheets?pageSize=300&includeAll=False (Caused by…
-
Index Collect with an IF and a Join?
Good morning all I'm after help with a complex formula concept. FYI these are not live data sheets just moc ups. Data Base Sheet Metric Sheet Bellow is the formula im currently using to pull contracted orders across to a second Metric sheet. =IFERROR(INDEX(COLLECT({DATA BASE | Customer}, {DATA BASE | Start Date},…
-
Formula to sum a column from a 2nd sheet with 1:many match across 2 sheets
Hello, I am stumped with a cross-sheet formula. I tried the AI tool but only received links to articles on cross-sheet linking, so I'm reaching out to the community for a life line. This is what I am trying to calculate: Sum [Est. Cost] from sheet: {Construction Estimates Details} only if the values in [Task Name] column…
-
Linking forms in a dashboard.
Hi, Currently when one wishes to link a form in a dashboard (not display a form, i mean hyperlink! but guess it would apply to forms in a dash too) You would need to get the url first of the sheet where the form derives from. Instead, it would be handy that when adding a hotlink, it would pop-up when 'Smartsheet item' is…
