Best Of
Re: Submitted Ideas Status
Hi @cschoenfeld
Thanks for posting your suggestion! Filtering Product Ideas is currently possible from the dropdown above the overall list:
We also added a quick-link filter at the top of the Product Ideas page.
Please note that while all feedback is collected and reviewed, the Product team only posts a public status on the top voted posts.
Cheers,
Genevieve
Genevieve P.
Re: Date match formula
=IF(AND(MONTH(TODAY()) = MONTH([Date]@row ), YEAR(TODAY()) = YEAR([Date]@row )), [Revenue Variance Explanation]@row , "")
I added in the year in case this is a running list.
Matt_A
Re: Is there a way to maintain currency formatting when within a formula?
Hopefully someone has a less convoluted version than this, but you could split and then recombine the dollar amounts using several helper columns and some of the text formulas, forcing Smartsheet to recognize the values as text:
NB! Without the 0 helper column and simply using the LEFT/MID/RIGHT formulas you lose the trailing 0 in the highlighted row of the first screenshot below
0 Helper
=Dollars@row + 0.001
Length =LEN([0 Helper]@row) - 1
Cents =MID([0 Helper]@row, FIND(".", [0 Helper]@row, 1) + 1, 2)
Hundreds
=IF(Length@row = 8, MID(Dollars@row, 3, 3),
IF(Length@row = 9, MID(Dollars@row, 4, 3),
IF(Length@row = 10, MID(Dollars@row, 5, 3),
IF(Length@row = 11, MID(Dollars@row, 6, 3), ""))))"
Thousands
=IF(Length@row = 8, LEFT(Dollars@row, 2),
IF(Length@row = 9, LEFT(Dollars@row, 3),
IF(Length@row = 10, MID(Dollars@row, 2, 3),
IF(Length@row = 11, MID(Dollars@row, 3, 3), ""))))"
Millions
=IF(Length@row < 10, "",
IF(Length@row = 10, LEFT(Dollars@row, 1),
IF(Length@row = 11, LEFT(Dollars@row, 2), "")))"
Dollars as Text
=IF(Length@row > 9, "$" + Millions@row + "," + Thousands@row + "," + Hundreds@row + "." + Cents@row, "$" + Thousands@row + "," + Hundreds@row + "." + Cents@row)
AdamSYNH
Re: Automatically Capture Completion Date When Status Changes to Complete
@VessyKlyce, just jumping in here to make sure you see @Paul Newcome's response!
Georgie
Georgie
Re: Automatically Capture Completion Date When Status Changes to Complete
My suggestion would be a Record a Date automation.
Paul Newcome
Re: Send Dashboard via email - manually and automated workflow
I like that idea of automations from Dashboards.
AngB789
Re: [UPDATED] Community Reward Program 🏆
I love getting the opportunity to help others while gaining badges and merchandise. We utilize badges for our pay for performance and annual reviews for us Admins.
AngB789
Re: Work With Flow - Operation Smile Story
Smartsheet helps me create smiles at my workplace by simplifying and improving our workflows and processes. I’m always looking for ways to make our systems more efficient, and Smartsheet gives me the tools to automate tasks, centralize data, and improve visibility across teams. When coworkers see how much easier their day-to-day becomes—from quicker approvals to clearer project tracking—it creates a ripple effect of less stress and more smiles all around.
mcullen
Re: Work With Flow - Operation Smile Story
Smartsheet = Smiles…. well like most of us in the Smartsheet world, Smartsheet has made me smile daily for years so much that I needed to do it full time! When I think of Smartsheet it's not just a software but a whole way of life! We are all here because we love something that really impowers us to do more with less and unlike most tools…. Smartsheet just works! This community is proof on how much we love Smartsheet because we are weird! 😎
Joe Goetschel
Re: Work With Flow - Operation Smile Story
I ❤️ using Smartsheet — it makes my job so much easier. But honestly, the best part is when I show someone else how it can save them time or simplify something, and they just light up. That moment is the best!
Peggy Parchert