-
Meet Lauren Dominique, our June Member Spotlight! 🎉
Someone start a drumroll please and let’s all congratulate @Lauren Dominique on being our June Member Spotlight! Lauren is an Executive Assistant at Connecticut Children’s in the US and a Smartsheet Community Champion. When she started her current role a few years ago, she had never heard of Smartsheet or used anything…
-
July Question of the Month - Join the conversation and receive a badge
Last month’s question has been one of my favorites so far. I knew you were awesome at your jobs, but you really surprised me with the wide range of knowledge, and experiences you have! We got coffee connoisseurs, bee keepers, fitness enthusiasts, a fingerboarding expert, and a whole assortment of artists. One of you trains…
-
Be aware of one-time Smartsheet login screen update
Hello Community, As part of our latest security enhancement related to the email TOTP login method launch, you may notice a one-time change in your login experience. Users accustomed to seeing their last login method (as shown in sample Image 1) will see a new login screen (as shown in sample Image 2) only once. What you…
-
Community Corner Newsletter [July 2024]
Greetings, Smartsheet Community! I'm Isaac, part of your dedicated Community Team. Welcome to another edition of our Community Corner Newsletter! I'd like to start with a huge shoutout to Marcela for her fantastic work on last month's newsletter. The photos from the beach cleanup campaign organized by the Social…
-
Email-based TOTP login method, now generally available!
Update as of July 1, 2024: The email-based TOTP (time-based one-time passcode) login method is now generally available. Please read the community post below for more details. Hi Community, Studies have consistently highlighted the vulnerabilities of password-based systems, including susceptibility to brute force attacks,…
-
Advanced Reports in Resource Management by Smartsheet now generally available!
Hi Community, We are excited to introduce "Advanced Reports," a new feature in Resource Management by Smartsheet. This release brings significant value to organizations utilizing Smartsheet and Resource Management. With "Advanced Reports," organizations can now automate their Resource Management reports—covering Time &…
-
[NEW] Welcome to the Webinars Topic!
Hi Community, If you love learning about all things Smartsheet, our newest addition will be a real treat for you. Introducing the Webinars topic — a place where you can find live, and on-demand webinars about best practices, feature releases, product specific deep dives, and more! Excited? We’ve got one more surprise for…
-
Introducing the PeerConnect Program!
Hey Smartsheet Community, We love how much you help each other, and the many friendships that have been born in the Community. Having peers by your side, and knowing someone else is in, or has been on a similar journey can be very validating and empowering. That’s why we’ve created PeerConnect. This is an opt-in program…
-
Certification Discount - Get certified this June & July!
Hi Community, If getting certified is one of your goals for 2024, we’ve got great news for you! This June and July, showcase your Smartsheet expertise by getting certified. We’re discounting the Core Product, Project Management, and System Administrator certifications — use code certification_success_24, to register for…
-
OPTION FOR CURRENT YEAR FILTER
I have yearly reports that I want the current year to populate, currently I have 2024 in place so it is working nicely. However I would like to not to go in and update to the current year every year. Is there something I could input instead of "2024" to get the current year? How about if I want last years data displayed?
-
Enable Comment Permission Level in Workapps
Please provide a permission option in Workapps that enables a user to Comment on a sheet without being able to edit the sheet. In 2021, Smartsheet released the ability for Workapps users to comment. However, since there is no view + comment level of permission in Workapps, a user needs to have Edit permissions in WorkApps…
-
Community で人気のコメント(3) 最初の出現箇所を見つけて日付を返す数式(COLLECT関数)
Smartsheet Community (英語版)で人気のコメントのうち、「いいね!」と思ったものをご紹介します。 しばらくサボっていましたが、第3回目は、コミュニティーアンバサダー(大使)のニック・コルナ (@Nick Korna)さんがコニー・コクラン(@Connie Cochran)の質問に答えて回答した「最初の出現箇所を見つけて日付を返す数式」についての記事です。 はじめに 同一の質問に同一人物から複数の回答がある場合、最初の回答や最新の回答を参照したい場合があります。 コクランさんの場合は、同一クライアントに複数のイベントがあり、最初の出現のイベント日を参照したい、という内容の質問です。 質問と回答の要約…
-
Adding new columns in the roll-up where data comes from the control center to the roll-up
I want to add some extra columns to the roll-up sheet, but I'm afraid it will break the links in the roll-up.
-
Help with formula again
Hello, Sorry that I have been away but the last discussion I had regarding a formula revison still does not work. I've simplified my field names below and provided an example of what I would like displayed for the compliance status. Scenario: If all 3 columns have check marks and the flag is blank, then compliant. If 0 or…
-
Sum If & contains
Hi, Hoping for some help with a Sum IF formula. I would like to sum if from 'Sheet 2' Value based on Sheet 1 project code. I have tried the below formula utilising 'Contains' however it is returning 0 rather than sum of project 304. Sheet 1 Sheet 2 Any assistance would be appreciated
-
I want my report to show Months in correct order, not alphabetically
I am currently trying to show data as a comparison over the last 2 years but I can't get the data to run in correct month order. I have had a look at rolling monthly data etc but don't understand how that works on the report.
-
Auto refresh dropdown list values
When creating a droplist list column it will auto populate with values already in the column whether in the same sheet or sourced from another sheet. However, after the dropdown list does not change thereafter. Most of the requests to auto refresh dropdown lists and use them in forms arise due to the inability of the…
-
Formula for returning a blank
This discussion was created from comments split from: Count all cells in a column that are NOT blank and do NOT contain a date.
-
Help with "Simple Project Portfolio" template
I really want to use the Simple Project Portfolio template but I can't seem to get everything in the "Save as New" folder to do so while keeping all its connections. Maybe I have missed a "how to use" section with this template or just not seeing something obvious any help is greatly appreciated. NOT REQUIRED: I learn best…