Summary fields - adding one column and subtracting a second column


Hi All,

I have been trying to get a simple formula to work and I am having issues. Maybe it is just my brain but would appreciate some help.

I have added and removed SUM after the = and neither work

=([VENDOR QUESTION Amount of Credit]:[VENDOR QUESTION Amount of Credit]) - ([AP QUESTION Amt $ Posted]:[AP QUESTION Amt $ Posted]) and when I hit enter I get #INVALID OPERATION.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!