Areas to explore

Get Product News
Discover and discuss the hottest new features and highly anticipated Smartsheet integrations.

Browse discussions
See what’s been recently shared and join those conversations that interest you.

Earn Badges + Swag
Let’s celebrate! Join now and start earning points, badges, and Smartsheet swag.

Get Help with Smartsheet
Find answers to your Smartsheet questions in English, Deutsch, Español, Français, Italiano, Português, and 日本語.

Webinars
Explore webinars covering quarterly feature releases, best practices and product-specific deep dives.

Show & Tell
Share and celebrate - whether a promotion, a new Smartsheet solution, best practice or badge. Share the good news and cheer on others!

Announcements

SmartStories - How has Smartsheet helped you advance your career?
Hello Community, SmartStories is back, highlighting the voices of the Community. This time around, the members are sharing how Smartsheet has helped them advance in their careers. Check out the video below, and get inspired by their success stories! Shout out to the Community members featured in this edition: @Darla Brown,…
December Question of the Month - Join the conversation and receive a badge
During November, we had a great conversation about AI, and how it's helping you to work smarter, not harder. We loved reading how you use it with your formulas, to analyze data, onboard new users, or even as a trainer to improve your skills faster. We also received excellent video responses, and you’ll see a selection of…
Smartsheet has been recognized as a Leader in the 2024 Gartner Magic Quadrant for Collaborative Work
Hello Community, Did you hear the great news? Gartner recognized Smartsheet as a Leader in the 2024 Magic Quadrant! Not only was Smartsheet recognized as a Leader in Collaborative Work Management for the second year in a row, but we were also recognized with a Gartner Peer Insights ™ ‘Customers’ Choice’ distinction for…
What view are you? Share your story and claim your badge
Hello Smartsheet Community, We love reading stories about the meaningful change you’re driving at work. Everyone has their own way of managing work, right? That's why we've ensured you always have a Smartsheet view that fits your needs. We want to hear how you are using Smartsheet and how it may change depending on the…
Improved Reporting Engine in Resource Management
Hi Community - We rolled out updates to improve your reporting experience in Resource Management. What's New: Faster Performance - Reports now run significantly faster, especially for large datasets. This performance improvement currently applies to Time & Fees and Expense reports, with improvements coming to Budget…

Recent Discussions

% complete using a duration of dates
I am trying to get a percent complete using dates. For example, I have a start date and a finish date to get the duration (let's say that is 96 days) and I want to find out the percent complete using today's date (automatically updated each day) as the task progresses in time. I can't seem to figure out how to use TODAY()…
Guidance Needed: Setting Up Bridge Integrations with Company Microsites
This discussion was created from comments split from: Join the new group for Bridge by Smartsheet!.
Add an active link or document to a form
Hi All - I can't seem to find a good process for this: add either a document as an attachment, or an active link, to a form that will be sent out to users (sharepoint, via teams). They would open the document or link, then respond to the questions/etc in the form. The users would not be uploading their own documents. I…
Need another option than INDEX MATCH
I am trying to pull data from 2 columns in one sheet into another (a name and a date) which worked great until there was another instance, which know I find out that INDEX MATCH can only see the first instance. I am looking for other options. Below is a quick example: Formulas being used are in bold and underneath are the…
Gnatt Chart Target Date Line
Is there a way to place a vertical line in a gnatt chart to show the target date?

Newest Questions

Gnatt Chart Target Date Line
Is there a way to place a vertical line in a gnatt chart to show the target date?
% complete using a duration of dates
I am trying to get a percent complete using dates. For example, I have a start date and a finish date to get the duration (let's say that is 96 days) and I want to find out the percent complete using today's date (automatically updated each day) as the task progresses in time. I can't seem to figure out how to use TODAY()…
formula to generate unique ID for this scenario
Hello all, So I am trying to work out how to do a formula to auto generate a sequential ID starting from row 18 like in the screenshot example. When a form is completed/submitted it will update each row automatically so was hoping also that the formula will update accordingly when the form is submitted and saved in reach…
Add an active link or document to a form
Hi All - I can't seem to find a good process for this: add either a document as an attachment, or an active link, to a form that will be sent out to users (sharepoint, via teams). They would open the document or link, then respond to the questions/etc in the form. The users would not be uploading their own documents. I…
Issues with passing JSON values
This discussion was created from comments split from: Point me in the right direction - Troubleshooting API.

Explore. Ask. Answer.

Find peer-to-peer information about everything Smartsheet related – from project management best practices to invaluable how-to guidance from fellow users and Smartsheet experts.

Ask a Question

SmartStories - How has Smartsheet helped you advance your career?
Hello Community, SmartStories is back, highlighting the voices of the Community. This time around, the members are sharing how Smartsheet has helped them advance in their careers. Check out the video below, and get inspired by their success stories! Shout out to the Community members featured in this edition: @Darla Brown,…
December Question of the Month - Join the conversation and receive a badge
During November, we had a great conversation about AI, and how it's helping you to work smarter, not harder. We loved reading how you use it with your formulas, to analyze data, onboard new users, or even as a trainer to improve your skills faster. We also received excellent video responses, and you’ll see a selection of…
Smartsheet has been recognized as a Leader in the 2024 Gartner Magic Quadrant for Collaborative Work
Hello Community, Did you hear the great news? Gartner recognized Smartsheet as a Leader in the 2024 Magic Quadrant! Not only was Smartsheet recognized as a Leader in Collaborative Work Management for the second year in a row, but we were also recognized with a Gartner Peer Insights ™ ‘Customers’ Choice’ distinction for…
What view are you? Share your story and claim your badge
Hello Smartsheet Community, We love reading stories about the meaningful change you’re driving at work. Everyone has their own way of managing work, right? That's why we've ensured you always have a Smartsheet view that fits your needs. We want to hear how you are using Smartsheet and how it may change depending on the…
Improved Reporting Engine in Resource Management
Hi Community - We rolled out updates to improve your reporting experience in Resource Management. What's New: Faster Performance - Reports now run significantly faster, especially for large datasets. This performance improvement currently applies to Time & Fees and Expense reports, with improvements coming to Budget…
Discover how others are benefiting from Smartsheet AI
Hey Community, Are you curious about AI, but haven’t tried it yet? Smartsheet AI tools are open to all customers until December 31, and your peers in Community have been exploring its potential. Now, we’re sharing their best insights with you. Discover what they had to say, and get inspired by all the ways they are…
Community Corner Newsletter [December 2024]
Hey everyone! It’s my first time introducing the monthly newsletter - if you haven’t met me or seen my name here in the Community yet, hello!! I’m Georgie, and I joined the Community team in October. I’m so happy to be here and love seeing how all you fabulous members help each other out every day! Before we get started, a…
Join us for a Accreditation Survey Prep & Survey Tools Community Call - Dec. 5 @1:30pm EST
Missing the excitement from Smartsheet Engage? We are too! Let’s keep the momentum going! Join us on December 5, 2024, from 1:30–3:00 PM EST / 10:30–12:00 PM PST for an exclusive Community Call featuring Regina Shelnutt, Accreditation Manager at Tanner Health. Regina will showcase her innovative Smartsheet solution for…
Restrictions to primary email changes, now generally available
Hi Community, We're enhancing security by restricting end users from changing their primary email address in the Manage Email Addresses UI under Personal Settings → Profile. Now, only System Administrators can modify a user's primary email address via the User Management UI in the Admin Center, and this will be limited to…
How to celebrate Giving Tuesday 2024 with the Smartsheet ERGs
Hey Community, I've had the privilege of getting to know quite a few of you this year, and we have some really smart, talented, and generous people around these parts. The holiday season is a time to give back, and each year on Giving Tuesday, our Smartsheet Employee Resource Groups (ERGs) carefully select nonprofits that…
% complete using a duration of dates
I am trying to get a percent complete using dates. For example, I have a start date and a finish date to get the duration (let's say that is 96 days) and I want to find out the percent complete using today's date (automatically updated each day) as the task progresses in time. I can't seem to figure out how to use TODAY()…
Guidance Needed: Setting Up Bridge Integrations with Company Microsites
This discussion was created from comments split from: Join the new group for Bridge by Smartsheet!.
Add an active link or document to a form
Hi All - I can't seem to find a good process for this: add either a document as an attachment, or an active link, to a form that will be sent out to users (sharepoint, via teams). They would open the document or link, then respond to the questions/etc in the form. The users would not be uploading their own documents. I…
Need another option than INDEX MATCH
I am trying to pull data from 2 columns in one sheet into another (a name and a date) which worked great until there was another instance, which know I find out that INDEX MATCH can only see the first instance. I am looking for other options. Below is a quick example: Formulas being used are in bold and underneath are the…
Gnatt Chart Target Date Line
Is there a way to place a vertical line in a gnatt chart to show the target date?
Countifs formula not returning a value.
Challenge: Countifs formula is not returning a value from a cross sheet. Any help would be so greatly appreciated. Summary: I am trying to pull in counts for a specific month and status for an application. The formula doesn't state any errors but it doesn't return the values. Formula: =COUNTIFS($Name18, {Status}, [JAN…
Does anything in range A appear in column B?
I am trying to set up a formula that lets me know if any of the Project Tittles in one sheet appear in any comments on a separate sheet. When the function should return "True", I get "#invalid data type" =IF(CONTAINS({Project Tittle Range 1}, [Comments]:[Comments]), "True", "False")
Issues with passing JSON values
This discussion was created from comments split from: Point me in the right direction - Troubleshooting API.
formula to generate unique ID for this scenario
Hello all, So I am trying to work out how to do a formula to auto generate a sequential ID starting from row 18 like in the screenshot example. When a form is completed/submitted it will update each row automatically so was hoping also that the formula will update accordingly when the form is submitted and saved in reach…
Freestyle Drawing on a Form
In our organization, we have found multiple use cases where users would like to submit a form and a data point we would want to capture from the form user would be a free style image either on a blank canvas OR the ability to upload an image and have the user "mark up" the image to answer a question or provide info.…

Ask a Question

Member Spotlight

“There was so much energy and positivity (at ENGAGE Seattle). Over the past two years, I have met so many people through Community, but finally had the opportunity to assign faces to names!”