-
Smartsheet Forward Q2 2024: New ways to unlock actionable insights
Hey Smartsheet Community, It’s with great excitement that I get to share with you a number of product enhancements we’re rolling out that will make it easier to uncover, view, and understand the actionable insights in your data. That way, you can better align resources and stakeholders and more easily make smart decisions…
-
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…
-
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…
-
$1B in annualized recurring revenue - Learn more and join the celebration.
Hello Smartsheet Community, We’re proud to share that Smartsheet has achieved a milestone of $1B in annualized recurring revenue. Many of you have been with Smartsheet for many years, seeing the product expand and evolve. From modest beginnings, Smartsheet has pioneered the enterprise work management category – now working…
-
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…
-
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…
-
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…
-
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…
-
Why is Duration2 in the dropdown in Project Settings but Duration isn't?
Why is Duration2 in the dropdown in Project Settings but Duration isn't? Duration is shown as a column Duration2 isn't! Yet when I change the Column heading Duration to Duration2 I get an Error Message saying Column 2 alreay exists. I need to find Duration2 Column or I need to use Duration to calculate dates. See photo Help
-
IF Formula Help
Im looking for help with an IF type formula that would return one of the below ratings "Strong, Average, Weak" based on the score in the first column and the indicative range sample in the third column. Im sure its something simple but it's got me stumped at present. Thanks in advance Rob
-
COUNT Formula for counting number of comments in another sheet
Hi! I am trying to figure out how to write a COUNT formula to count the number of comments in another sheet by using a cross-sheet reference. How do you include a comment count in a Smartsheet formula?
-
Same Value in a column
I want the values of the columns to be automatically the same all the way down the sheet unless I change the values. As new entries come in from the form it should automatically put in whoever I have listed.
-
Bespoke year / fiscal year rather than calendar year?
Hi Everyone, We have a system of many sheets which reports various metrics of this year and the previous two years. The idea being we are constantly seeing three years metrics for comparison on dashboards and reports with no intervention. Directors have asked if we could instead show metrics for the company year which runs…
-
Are there limits to Calendar App Secondary Grouping?
I created a calendar, based on a report that pulls data from 29 sheets. The report looks fine. The calendar app calendar has a Group Data By (there are 3 "Steering committee") and a Secondary Grouping (there are about 30 "workstreams"). All looked great yesterday, but today my calendar is missing the data for one group. It…
-
Looking for More Efficient Formula for Calculating Weeks
Is there a more streamlined method to calculate the number of weeks between a specified start date and a set date without resorting to intermediary calculations or a helper column? I currently employ formulas to determine the day difference between the start date and the set date, and then divide this figure by 7 to derive…
-
Visual Studio Python Extension Smartsheet API Not Working
My Python environment is handling the Smartsheet API Token just fine. This is great news! But, my Visual Studio with Python extension is erroring out. Any suggestions?
-
Smartsheet - CountIf Metrics
Hello, I am working on building a dashboard and starting with my metrics sheet. I cannot figure out the formula that I need to populate the correct information. I am needing it to pull from "Sheet A" the number of rows whose status is "Complete" and the "Date Submitted" was in Q1 2024. I will be doing this for multiple…
-
Unable to transfer ownership of specific Smartsheet items
I used to be able to click share for a specific sheet and make someone a owner of a specific document. A few weeks back, the "Make Owner" option stopped showing up. Is there a reason this option was removed and what is the workaround?