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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!