-
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…
-
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…
-
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…
-
Community Corner Newsletter [April 2024]
Hey hey everyone, Rebeca here. I’m back to introduce April’s newsletter, and I’ve got a lot to share with you, including new topics, badges and a giveaway. But first things first, big shout out to @Genevieve P. for the great March issue. She really inspired me to explore my country even more with the eyes of a tourist!…
-
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…
-
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…
-
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…
-
I am using IF, AND, CONTAINS - Result coming wrong
here the formula - the answer should False IF(AND( CONTAINS([ASSET NAME]@row, {A 2024 Range 3}), CONTAINS("INTERNATIONAL", {A 2024 Range 5}), CONTAINS([NAME HELPER]@row, {A 2024 Range 2}), CONTAINS("Completed", {A 2024 Range 4}) ), "TRUE", "FALSE") Any advice please :) Thanks!
-
dynamic dashboards
hi, I am trying to make my dashboards dynamic ; I am using a form where a choice is made via a drop down menu, then the user submits the forms and via a formula in the background (in a sheet), the dashboards data are updated. This works well but requires about 20 seconds to update. Is there any other way to accomplish this…
-
Show both parent and child rows in report, even if the Parent doesn't meet the criteria
i have sheet with parent and children tasks and in my report i want to see the children tasks with the parent row. when i try to do this i show only the children.. there is any way to show chldren tasks with parents in report>??
-
Divide By Zero Error with Average
Hi, I'm trying to set up a formula that averages the scores for four columns, but doesn't bring up the Divide by Zero error if the scores haven't been entered yet (either leaves blank or puts a 0). The Average formula works fine but I can't get the IFERROR part to work. Current formula: =ROUND(AVG([LOR 1]1:[LOR 4]1), 1)…
-
I am trying to get the percentile of responses that return "1-2" if the responded "4 Months" in
I am trying to get the percentile of responses that return "1-2" in a column if the response is "4 Months" in another column. =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, "4 Months", 0.5)) or =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, {Survey Time}, "4 Months", 0.5))…
-
Formula for totaling 2 selections from a drop down in sheet summary
Hello,I am trying to write a formula for my sheet summary. I would like a formula that gives me a total number when Instructional Design and Learning Solutions is selected. I have been successful with the countif formula when I want to count just one criteria but not two.
-
Formula to return a checkbox on Sheet B, if a % column in Sheet A = 100 + move rows
Hello there, I have 2 sheets: Sheet A - Base File, where i have % Column where i input the current numbers. Sheet B - Transfer to File, where i need to add a checkbox to a row, if the % Column in Sheet A is 100 %. I have managed to make the reference where: =IF({Base File Range 5} = 1, 1, 0). BASE FILE TRANSFER TO FILE My…
-
How to connect Smartsheet with an other app?
-
Is there a way to create a flow chart that leads to a result depending on how the user answers?
Hi! I currently work in a manufacturing plant where in order to quote a new project we need to create a chart showing the number of people and the line speed required to run the project. I am currently the only one on my team that has the knowledge to make these, but would love to create a flow chart type system where…
-
SUM(IFERROR(INDEX(COLLECT(MATCH))))
I may have just the brackets wrong or overthinking this but I need to return the SUM of column 'eOEM' when the 'Date of report' column is in the next 7 days AND the 'transaction status' column is "New". The formula I have is =SUM(IFERROR(INDEX(eOEM:eOEM, COLLECT(MATCH("New", [Transaction Status]:[Transaction Status],…