Building a red ledger

Tom deGroh
edited 12/09/19 in Formulas and Functions

My apologies I am not even sure how to search of this, but I am trying to build a red ledger. Basically have it set up so there is a required sale every day and anything under, shows negative, anything over just shows zero. 


So I have 1 column that has the number sold, next is sum of column1 - 5000, the last is column2/100. That last column I would like to add an if statement to zero out positive values. 






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!