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, 日本語, and Español.

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

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…
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…
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 &…

Recent Discussions

Please Allow Multiple Admins for Data Shuttle and DataMesh
Our team is really struggling to troubleshoot issue when the owner of a DataMesh or Data Shuttle is out of the office. Please allow multiple Admins and/or Editors (or, at the very least, Viewers) for these critical tools.
Formula to determine the date that another cell was populated
Hi, I was trying to find an answer to a question that advised how I can show a date in one column that shows the date text was first added to a previously blank cell in another column. So I have one column called "Date of response" and I want that to auto populate with a date when another field is first updated i.e.…
Formula for Previous Workday
Hello, I've seen some formulas here that are close to what I'm looking for, but nothing that exactly matches. I've created a payroll calendar in Smartsheet and I want to alert a user the workday before the payroll deadline, excluding holidays. The field is [Alert Date]@row. Thanks in advance!
Move Rows Automation Suddenly Failing - Multiple Sheets
Hi. I manage 3 very similar smartsheet tools for 3 different office's training request intake and approval systems. Once requests are approved, an automation has successfully been moving them to each site's Request Archive Sheet. This has worked as expected since March. For some reason today this feature has suddenly and…
Conditional Formatting Font color change
Hello, Is there a way to change the font color of a single items in a dropdown list on the specific column only and not apply the font color change to the entire row? Thank you! TaliN

Newest Questions

Trying to find the top three categories for Dashboard Metric
Hello, I have a list in my primary column with categories ([Primary Column]52:[Primary Column]93). The column to the right COUNT column has counts for the categories ([count]52:[count]93). I also have a ranking column next to that with the following formula in it from row 52-93 —> =RANKEQ([Count]@row, Count52:Count93, 0).…
Conditional Formatting Font color change
Hello, Is there a way to change the font color of a single items in a dropdown list on the specific column only and not apply the font color change to the entire row? Thank you! TaliN
Unable to input external data to SmartSheet through API
Hi community members, I'm working on a project to fetch our students' quiz score data from Blackboard, an education platform, and send it to Smartsheet using the API. I've successfully retrieved the data from Blackboard and prepared it for transfer to Smartsheet, ensuring the data is correct and the column IDs match those…
How to tag specific people in slack with Request Update Workflow
One of my project managers is managing a very large cross functional project with 8 Product Managers owning different workstreams. We'd like to use automated workflow request update capability to request updates weekly for any tasks past due that do not have a status of complete or out of scope. This part we've been able…
If statement with sumifs not working - yet each element does
Hello, I have what I consider a basic formula that is not working: =IF({Finish} = "", SUMIFS({MPST Savings}, {Location}, =Label@row, {Target Finish}, AND(>DATES3, <=DATES4)), SUMIFS({MPST Savings}, {Location}, =Label@row, {Finish}, AND(>DATES3, <=DATES4))) Yet, if I enter the true portion it works: =SUMIFS({MPST Savings},…

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

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…
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…
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…
Please Allow Multiple Admins for Data Shuttle and DataMesh
Our team is really struggling to troubleshoot issue when the owner of a DataMesh or Data Shuttle is out of the office. Please allow multiple Admins and/or Editors (or, at the very least, Viewers) for these critical tools.
Formula to determine the date that another cell was populated
Hi, I was trying to find an answer to a question that advised how I can show a date in one column that shows the date text was first added to a previously blank cell in another column. So I have one column called "Date of response" and I want that to auto populate with a date when another field is first updated i.e.…
Formula for Previous Workday
Hello, I've seen some formulas here that are close to what I'm looking for, but nothing that exactly matches. I've created a payroll calendar in Smartsheet and I want to alert a user the workday before the payroll deadline, excluding holidays. The field is [Alert Date]@row. Thanks in advance!
Move Rows Automation Suddenly Failing - Multiple Sheets
Hi. I manage 3 very similar smartsheet tools for 3 different office's training request intake and approval systems. Once requests are approved, an automation has successfully been moving them to each site's Request Archive Sheet. This has worked as expected since March. For some reason today this feature has suddenly and…
Conditional Formatting Font color change
Hello, Is there a way to change the font color of a single items in a dropdown list on the specific column only and not apply the font color change to the entire row? Thank you! TaliN
Using a Form for a Check-in/out build.
Hello. I am using a form for visitors to fill out. We want this to be put on an ipad to fill out or have an option for a QR code. It looks like this.. pretty basic questions. I want to have it so when you have check-In selected it has all questions, and when check out is selected it only has the name of who is checking out…
In the Calendar App, can you make it filter on a field by default
I have a sheet with a lot of data. I have created a view for it but need it to be filtered on one field. I can set that up fine but now I (and others I share it with) need to reset that filter every time I go in to view it. Is there a way to have that filter automatically set?
DocuSign Integration Isn't Generating Documents
We are currently unable to generate any documents using the DocuSign Integrations. When I click on the mapping to use, it ask me to sign in, when I click the sign in link it takes me back to the mappings page, click the mapping to generate, asks me to sign in again. Has anyone else experienced this issue? We have been…
File Attachment to Multiple Rows in a Sheet
When creating document mapping sheets for Projects, or Functional and Non-Functional Requirements response sheets for RFPs, it would be greatly helpful to be able to attach a single file to Multiple Rows in a Sheet. Now, we can only upload a file to a single row, but if that one file applies to multiple rows, it would have…
Move row to another sheet not working
Hi all, has anyone else experienced issues when moving rows to another sheet? I've got two colleagues, one of whom is actually owner of both - original sheet and destination sheet. When they try to move the row from one sheet to another, it just doesn't work. I mean, it does, as the row appears in the destination sheet,…

Ask a Question

Member Spotlight

"That’s something I’ve learned from the Community - so very often, there’s more than one solution to the problem we’re trying to solve. It’s so fun to have people (with you) as you talk through all the creative and innovative possibilities!”