-
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…
-
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…
-
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…
-
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…
-
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…
-
Resource Management - View Only Access
View Only Access for Non-licensed Users for Resources. We would see a lot of value if users who are not licensed could look at RM.
-
Global Updates Simply DO NOT WORK
I have tried to do a simple text change for a cell and it simply does not work. I am using the Find / Replace option to simply change the text. I have tried "exact match" and "contains". The test is marked as successful but when I open the sheet the old text is still there. I have also tried in the past to make changes to…
-
Count # of networkdays if a condition is not met
Hello, I want a formula to count the number of workdays between when an item was assigned only if a condition is not met. =IF(Request Status - Contracting]@row <> "Contract work Complete", [Date Assigned to CM]@row, TODAY()) I want the # of days counted since an item was assigned to a manager only if the manager has not…
-
How can I make sure that I always share contacts with full names?
Hello everyone, I have an issue with the shared list displaying full names and not just email addresses. I am an admin on all sheets and if I try to update an email address and replace it with one in my Contacts list with their full name, it still doesn't show the full name in the shared list. For example: And this is my…
-
Count Ifs Multiselect drop down
Good morning! I am running into an issue with my formulas. I currently have a log sheet that records detailed information about jobs, and a metrics sheet (see above) that is used to tabulate certain information. My metrics sheet information is broken down between internal/external design work that is active or has been…
-
Our first Overachiever Guest is here! [RECAP] Homecare Homebase x Sara Cook: Putting People
The latest episode of the Brand Collective Podcast is a treat for all of us. Featuring one of our very own Smartsheet Overachievers — @Sara_Cook! She’s the Marketing Director of Brand Management and Content at Homecare Homebase (HCHB), and also participates in several programs with Smartsheet other than the Overachievers,…
-
Date formats
I have a date that is coming into my sheet via the CRM connect and the format is M/DD/YYYY. I need to create a formula that calculates 2 weeks prior to that date but cannot because Smartsheet does not recognize that as a correct date format.
-
Now Announcing - Data Shuttle Error Notifications!
Hi Community, I am beyond excited to announce a much anticipated Data Shuttle feature - workflow error notifications! As a Data Shuttle workflow owner, you will now receive in-app and email notifications for erroring workflows with links to the run log so you can see details about the error. You can learn more about Data…
-
Why are my reports pulling in other informataion
I have a report that I have filtered to pull in tasks for individuals. It's supposed to pull in any tasks that do not have a status of 'Complete' or 'Not Needed' but multiple tasks are pulling in that have been completed for many months. How can I fix this? Report:
-
SUM(IFERROR(INDEX(COLLECT(MATCH))))
This discussion was created from comments split from: SUM(IFERROR(INDEX(COLLECT(MATCH)))).