Using sheet summary fields within sheet formulas


Hi, I have a problem where I am trying to use smart sheet to generate the sell price of products based on a fixed % margin. Using a margin that is fixed is simple, I just put the value into the column formula. However, if I want to adjust the margin, I had hoped to use the sheet summary to do this.

I have used sheet summary fields before in formulas, adding together various values, and it worked. However every time I try and use any kind of mathematic equation that is not a simple addition, the formula spits out "INVALID OPERATION".


=1 + Margin# works

=1 - Margin# invalid

=BUY@row * (1 - Margin#) invalid

Any ideas of other workarounds?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!