Summing data and applying parenthesis to negative value.
I need to sum 3 pieced of data, subtract a value and then show the value in a parenthesis for any that equal a negative value.
I have seen a post about this formula, but how do I use this with the the other sum function:
=VALUE(MID(ColumnName@row, 2, 10))
My formula:
=SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row
Thanks Kristi
Best Answer

Lets try wrapping the math part in the middle of the text string in parenthesis so that it calculates before converting to a text string.
=IF(SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row>= 0, SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row, "(" + (SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row) + ")")
Answers

I was given this formula by a coworker but is not working either.
=IF(LEFT(Number2, 1) = "", "(" + ABS(Number2) + ")", Number2)

Try this:
=IF(SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row>= 0, SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row, "(" + SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row + ")")

I am getting unparsable. It is like there is a missing parenthesis somewhere in there. Trying to figure it out

I don't see any out of place or missing parenthesis. Double check that I spelled your column names correctly.
Are you able to provide a snippet of the formula in the sheet similar to the snippet below?

This calculation for 2023 In Year will be a negative value. The team wants it to show in parenthesis like normal accounting formats in excel here.

What about the formula you said was giving you the error? That one should be working for you.

Here are the errors I am getting and the formula used. #INVALID OPERATION

Lets try wrapping the math part in the middle of the text string in parenthesis so that it calculates before converting to a text string.
=IF(SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row>= 0, SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row, "(" + (SUM([Financials 2]@row:[Financials 4]@row)  [Financials 1]@row) + ")")

Any way to incorporate a thousands comma in here should the numbers be that large? i.e., $2,000 displayed as ($2,000) rather than ($2000).
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!