Best Of
Connect your Smartsheet data with AI tools across your business
Did you know Smartsheet integrates with Amazon Q Business, Atlassian Rovo, Glean, and Microsoft Copilot? Get insights from your Smartsheet data alongside data from across your systems through our dedicated Smartsheet connectors for enterprise AI tools:
- Amazon Q Business: Smartsheet and AWS have teamed up to create a powerful connector to Amazon Q Business, a generative AI assistant that lets you sync Smartsheet data and quickly get answers about your projects, tasks, and content.
- Atlassian Rovo: Access your Smartsheet data alongside company data with Rovo’s dedicated Smartsheet connector, so you can deliver accurate, personalized AI insights across your teams.
- Glean: Connect Smartsheet to Glean to find the real-time data you need from sheets, dashboards, and reports, generate trusted answers, and automate work.
- Microsoft Copilot (in public preview): Index your sheet content and quickly find Smartsheet data using Copilot chat and search with the Smartsheet Microsoft 365 Copilot connector.
Learn more about each of our AI integrations (including how you can access and set up each connector) on our website.
Elizabeth Matson
Re: Smartsheet recognized as a Customers' Choice in the Gartner® Peer Insights™ + Giveaway
Today is the day! Thank you for joining us in celebrating this recognition and for sharing so many clever and unique ways you use Smartsheet! I'm thrilled to announce the grand winner of our giveaway.
A huge congratulations to @Webb_E! 🎉 I'll be in touch with you shortly. Thank you to everyone who joined in the celebration! ✨
Rebeca S.
Re: Insert commas into formula dollar amount populated from another cell
This should take care of it:
IF(LEN(INT(ABS([ROM Value]@row))) <= 3, RIGHT(INT(ABS([ROM Value]@row)), 3), IF(LEN(INT(ABS([ROM Value]@row))) <= 6, IFERROR(IFERROR(MID(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 5, 3), LEFT(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 3)), "") + "," + RIGHT(INT(ABS([ROM Value]@row)), 3), IF(LEN(INT(ABS([ROM Value]@row))) <= 9, IFERROR(IFERROR(MID(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 8, 3), LEFT(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 5, 3), LEFT(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 3)), "") + "," + RIGHT(INT(ABS([ROM Value]@row)), 3), IF(LEN(INT(ABS([ROM Value]@row))) <= 12, IFERROR(IFERROR(MID(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 11, 3), LEFT(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 9)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 8, 3), LEFT(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 5, 3), LEFT(INT(ABS([ROM Value]@row)), LEN(INT(ABS([ROM Value]@row))) - 3)), "") + "," + RIGHT(INT(ABS([ROM Value]@row)), 3)))))
Paul Newcome
Re: Convert a Sum into Currency format $#,##.00
Here is the base formula for adding commas up to 999,999,999,999.99
=IF(LEN(INT(ABS([Total Column]@row))) <= 3, RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 6, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 9, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 8, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3), IF(LEN(INT(ABS([Total Column]@row))) <= 12, IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 11, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 9)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 8, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 6)), "") + "," + IFERROR(IFERROR(MID(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 5, 3), LEFT(INT(ABS([Total Column]@row)), LEN(INT(ABS([Total Column]@row))) - 3)), "") + "," + RIGHT(INT(ABS([Total Column]@row)), 3))))) + IF([Total Column]@row - INT([Total Column]@row) = 0, ".00", RIGHT([Total Column]@row - INT([Total Column]@row), 3))
Paul Newcome
Re: Question about currency formatting
Hi @Murz
You're right that Smartsheet doesn't provide native number formatting (like commas for thousands) within formulas. You're currently adding a dollar sign ("$") manually, which works for values under 1,000 — but it doesn’t add commas for larger numbers.
In my solution, I handle this by treating the number as text. I convert the integer portion of the number to a string using "" + INT(...), and then use LEFT, MID, and RIGHT to manually insert commas based on the number of digits.
The decimal part is also handled as text using ROUND(... * 100, 0) to extract cents, and then padded using RIGHT("00" + ..., 2).
It’s a bit manual, but this lets you generate a string like $210,000,452.25 without using TEXT(), which isn’t available in Smartsheet.
="$" +
IF(LEN(INT([Transaction (Receipt) Total]@row)) = 9,
LEFT(INT([Transaction (Receipt) Total]@row),3) + "," +
MID(INT([Transaction (Receipt) Total]@row),4,3) + "," +
RIGHT(INT([Transaction (Receipt) Total]@row),3),
IF(LEN(INT([Transaction (Receipt) Total]@row)) = 8,
LEFT(INT([Transaction (Receipt) Total]@row),2) + "," +
MID(INT([Transaction (Receipt) Total]@row),3,3) + "," +
RIGHT(INT([Transaction (Receipt) Total]@row),3),
IF(LEN(INT([Transaction (Receipt) Total]@row)) = 7,
LEFT(INT([Transaction (Receipt) Total]@row),1) + "," +
MID(INT([Transaction (Receipt) Total]@row),2,3) + "," +
RIGHT(INT([Transaction (Receipt) Total]@row),3),
IF(LEN(INT([Transaction (Receipt) Total]@row)) = 6,
LEFT(INT([Transaction (Receipt) Total]@row),3) + "," +
RIGHT(INT([Transaction (Receipt) Total]@row),3),
IF(LEN(INT([Transaction (Receipt) Total]@row)) = 5,
LEFT(INT([Transaction (Receipt) Total]@row),2) + "," +
RIGHT(INT([Transaction (Receipt) Total]@row),3),
IF(LEN(INT([Transaction (Receipt) Total]@row)) = 4,
LEFT(INT([Transaction (Receipt) Total]@row),1) + "," +
RIGHT(INT([Transaction (Receipt) Total]@row),3),
INT([Transaction (Receipt) Total]@row)
)))))) +
"." +
RIGHT("00" + ROUND(([Transaction (Receipt) Total]@row - INT([Transaction (Receipt) Total]@row)) * 100, 0), 2)
Re: Dynamic Dashboard Template Customization
Thank you @NeilKY
I updated the demo dashboard with instructions on browser refreshes to get the updated filter results.
Here is a short demo video.
Re: Registration is open! Come be in community at ENGAGE 2025
Yep! Three of us should be attending this year! Super excited.
Angelina
Re: MILITARY TIME FORMAT FORMULA
Try replacing the part that outputs the time with this:
SUBSTITUTE(TIME(RIGHT(Created@row , 8), 1), ":", "")
.
Paul Newcome
Re: August Question of the Month - Join the conversation and receive a badge
What’s the best thing you’ve seen on the Smartsheet Community platform?
I am always happy to see when users offer a solution that isn't pushing a third-party integration. A lot of us work in rigid corporate environments where we don't have the option or flexibility to introduce an add-on from a new vendor. Creative ways to customize the Smartsheet core features or preparing samples from the EAP have been great ways where the Community platform shines.
ss_innovation
Re: Printing Gantt stuck in Quarters
Hmm, mine prints or exports just the same as it shows in my gantt chart within Smartsheet. Here's a few suggestions:
-I would double check that you have your gantt chart zoomed in or out as needed:
-If that doesn't fix it, you can go into the Project Settings (gear will appear in gantt mode in the top right corner) and adjust "Gantt Timescale Settings" as needed
-If the problem is still persisting beyond that, you can always reach out directly to Smartsheet Support:
Hope this helps!:)
brianschmidt