Negative Number Formatting in Parenthesis

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.'

Cathy Salscheider

This could be connected to the request to have a numeric only column type. Then standard numeric formatting could also be implemented at the same time.