-
May Question of the Month - Join the conversation and receive a badge
Last month, we asked you to share something you would try if you knew you couldn’t fail, and the responses showcased the beautiful diversity of our Community. As some of you pointed out, failure is an important part of learning and improving, but it’s still amazing to know what you would pursue if that wasn’t a concern. I…
-
Meet Monique Odom, our April Member Spotlight! 🎉
Let’s get loud for @Monique_Odom_Comcast, our April Member Spotlight and Smartsheet Community Champion! Monique is a Business Process Excellence Manager at Comcast and calls Pennsylvania home. At a previous company, the fateful day came when she was asked to manage a platform she had never heard of before - something…
-
The paradox of governing user autonomy
Hello Community, In the world of hybrid work and AI’s promises to transform the workplace, IT departments find themselves in the seemingly paradoxical position of expanding access to information while also protecting it from ever-evolving threats. Chris Peake, Smartsheet’s CISO & SVP, Information Security, shares how we…
-
Be aware of upcoming changes to your Smartsheet login options
Hi Community, Studies have consistently highlighted the vulnerabilities of password-based systems, including susceptibility to brute force attacks, phishing, and password theft. Such risks not only jeopardize data integrity but can lead to severe repercussions. As a part of our ongoing commitment to enhancing the security…
-
Community Corner Newsletter [May 2024]
Hello everyone! It’s Arsineh from the Smartsheet Community team. It’s been an active month on Community and there’s so much I’m excited to share with you. In case you missed it, check out the April Newsletter by Rebeca to discover some newly introduced Smartsheet badges and topics and get a peek at Rebeca’s beautiful…
-
Welcome to the Government Community!
Hello! This is a space for Smartsheet and Smartsheet Gov users that work in all levels of government to connect, share ideas, challenges, best practices and how you are using Smartsheet and Smartsheet Gov to create impact. My name is Chris, I lead marketing for the Smartsheet Gov platform and am excited to get to know you…
-
Are you attending Smartsheet Gov Forum?
Are you attending Smartsheet Gov Forum, the inaugural customer event for users of the Smartsheet Gov platform? Let us know! Introduce yourselves and get a head start on your engagement and networking! Not registered yet? Sign up while there’s still space available to come sharpen your skill set, deep dive into the…
-
Smartsheet named Community of the Year!
Hello, I’m happy to share that our Smartsheet Community has been named Community of the Year in the Super Forum Customer Awards 2024. Super Forum 2024 marks the 14th year of this annual conference by Higher Logic hosted in National Harbor, MD. With Higher Logic representing over 350K online communities – this recognition…
-
Nominate Peak Humans & get a badge!
Hi Smartsheet Community, We loved learning about what operating at your peak looks like for you, and now, we want to give you the opportunity to recognize and celebrate others, and earn cool badges as you do it 😉 The Operate at Peak Human campaign is a celebration of humanity. Recognize someone who does a great job in any…
-
Get help right away with the Premium Support Package
Hi Community, Looking for help with your Smartsheet and want it right away? We’ve got you covered. The new Smartsheet Premium Support Package is an improved enterprise grade support experience for customers that need prioritized support. Formally known as the Professional Support Package (Pro Support), the Premium Support…
-
Automated email not showing updated smartsheet
So i have an automation set up for a Sheet, triggered by date, goes out every day at 10AM est as an email to my team. However, updates we made today at 10:30AM are not included. Is there something we need to do?
-
Countif with Dates
HI all, I'd like to ask your help. I am trying to count the number of items which are planned for particular dates, so the formula should be easy yet.. I get "0" which is incorrect. I need this for my metric to later use it for burn up chart. =COUNTIFS({W2 System Test Tracker Range 1}, [Column2]$2) the bit "W2 System Test…
-
How to remove one tag from a multi-select column without removing the other tags in that column
Automation gone wrong! I set up an automation to help me with tagging our marketing content. But when I ran it, it added the tag "Client Stories" to every cell in the Content Programs multi-select column. I would like to remove the "Client Stories" tag from the entire column without removing the other tags since it's a…
-
MAX(COLLECT multiple values
The sheet I am working on keeps track of the most recent dates that an item is requested. One of these items have 2 different item codes, but they are an equivalent item. Let's say Item1 and Item2 are different names, but if either is requested, it counts for the same thing. The current formula to return one value is…
-
Resource Management Analytics Report export file name
Hello: Resource Management Analytics Report export to csv generates a new file name each time. I wish to use the same file name each time as part of an automation process. Goal: regularly export file to known file location with the same file name, overwriting the existing file. Then use Data Shuttle to pull this report…
-
How do I set a task dependent on availability of a customer resource
I want to set a group of tasks dependent on the availability of a lab. I do not have the advanced resource management capability. I cannot use non-working days as this affects all activities on the plan. Other options?
-
Automation help or formula for connecting rows
AW Placement request form below takes in all of the school placement requests via a form. Once the column AW REQUEST STATUS is 'approved by leader' it is automatically moved to Students/Instructors - AWI The ANCHOR ID transfers over from AW placement request sheet to students\instructors - AWI - when approved by leader…
-
Master Out of Office Calendar Sync with Individual Project Gantts?
Hi! I manage several different projects with separate gantt charts, all with different project teams, and I struggle with cross-checking everyone's ooo schedules when I'm updating timelines. I would ultimately like to find a way to have a Master OOO Calendar that be pulled into the gantt charts based on the people assigned…
-
C# datatable to upload to a smartsheet API
Is there a quick way to upload a C# datatable object into a smartsheet sheet through API without doing it cell by cell? Thank you!
-
Setting up Automatic Provisioning for users
I'm setting up automatic provisioning for users with AD and at the portion where it is asking for my API Key and Tenant URL. I have the Key, but I'm wondering where I can find the Tenant URL? Is there one specific to our Tenant or is there a generic URL?