Sign in to submit new ideas and vote
Get Started

Negative Number Formatting in Parenthesis

Jake Gustafson
Jake Gustafson ✭✭✭✭✭✭

As a Smartsheet user, I want a standard numbering format to display negative numbers in parenthesis with proper thousands/millions/etc. commas and currency symbols, in order to visually display negative numbers in more of an accounting style rather than the standard negative symbol.

I've had multiple colleagues ask if there were ways to do this. The following formula is about as good as we've gotten, but that is lacking the proper comma separator to display larger values properly.

  • =IF(column@row >= 0, "($" + ABS(column@row) + ")", "($)" + ABS(column@row))

Unless someone has a surefire solution, I'm thinking this would be a nice feature to display things differently with a 'click of a button.'

2 votes

Idea Submitted · Last Updated