-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
Industry Talk - Connect with peers in your industry!
Hi Smartsheet Community, We noticed you want more ways to connect with members in your own industries, and we think that’s a fantastic idea! Today, we’re excited to launch a new topic where you can engage with your peers — Industry Talk. This is a space dedicated to the different industries, each with its own topic and…
-
Introducing our new video series - SmartStories!
Hi there Community, Did you participate in our Question of the Month back in November? So many of you shared the Smartsheet features you were thankful for, and we LOVED your responses. We liked them so much, that we decided to prepare something special to showcase a few: Big shout out to the very cool members featured on…
-
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…
-
Sharing content visible per User
I am trying to share a training status per user. Report wont work because I do not want to share source sheets with the users. Is there a workaround for this ? i tried with the dashboard, it wont work, maybe im doing something wrong. thanks!
-
Looking for a Consultant to help convert a complex multi-sheet Excel file to Smartsheet
Hi. We are looking for a Smartsheet "consultant" to help us convert a complex cost model spreadsheet to Smartsheet. We have looked at the various templates and don't believe anything existing will meet our needs. We are a marketing agency and use the excel sheet to create and track profit and loss for all our client…
-
Trouble with long date formula
Hi, I am working on something that will tell staff when the open window for a visit is, based on the visit category. Rule 1: Visits in the category of 1, 2, 3-5, 6-10, and 11+ years should be annually and the window is their DOB +/- 1 month. This portion of the formula works. Rule 2: 3rd trimester visit should start 197…
-
Add value to a checkbox
How do I assign a value to a checkbox so that if it is checked it equals "800" and that 800 can be added to an addition formula?
-
Same Level Multiple Approvals
Is there a way to sent out a request that contains multiple approvals? There is a situation where we have a record that may contain anywhere from 1 to 3 approvals. All approvers have the same authority. To tally the approvals I would create a separate column that evaluates the decisions of either all approved, all declined…
-
How do I always reference a child row immediately below the parent row(In the same column)?
Probably a basic way to do this but I cant get it to work. I need the circled cell to always refer to the cell immediately below it. So the circled cell will show "OFF HIRE' from the blue row until a new row is inserted in between the 2 and then it will refer to the new row's cell.
-
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…
-
Formula using Index and Match to reference another sheet only returns first item
I am using an Index/Match formula to lookup a person associated with a specific region. I have a sheet setup as a lookup table named Gift Card Approver with 2 columns: Region and Approver. In my main sheet I have a formula that pulls the region from the current line and uses that to lookup the approver in the Gift Card…
-
Help with IFS formula
I have a Smartsheet that tracks all grant applications in my department. Among other columns are "Application Due Date" and "Total Award Requested". I would like to be able to report on the sum of all funds applied for during a fiscal year. The AI formula creation tool produced the formula below. It looks like it should be…
-
Any ideas with an issue displaying web content on dashboards?
I've been experiencing an issue since yesterday with displaying a web content widget that pulls content from Excel. I get a Microsoft login page in place of the widget and when I click Sign In, it says I am already logged in. I can access the file outside of the dashboard fine in Sharepoint. Any ideas would be greatly…