Conditional Math Difference

Options

Great Morning, I would like to create a condition to apply a basic math difference to identify savings in a project. Ex: Original Budget minus (if there is a value on the estimate column only, and not actual expenses yet, deduct the estimate amount BUT if the actual expense column has a value different than $0, use this column instead of the estimate column). in other words to replace the information once the actual expenses column is filled out; in the meantime, use the estimate column to provide preliminary savings. I hope I made myself clear (screenshot attached)

REVISED BUDGET - EITHER REQUISITIONS OR ACTUAL EXPENSES COLUMN (whichever has a value different than $0).


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!