I want to return a negative number as this sheet will be used for our accounts payable team.


I'm using a simple Sum formula. I want to display this as a negative. conditional formatting to change the color will not work. It needs to either be -$192,000 or (192,000)

=SUM([2021 Total]1:[2021 Total]46) = 192,000

I've tried sumIF with no luck too.

it's really just adding up all the values but I need the total to be negative. Please help.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!