# Formula to calculate remaining savings to end of project

Options
✭✭✭✭✭
edited 03/13/23

Hello,

I am trying to create a working formula to display remaining savings to end of project. I am using the formula below and seeing and "UNPARSEABLE" error, of course. I'm terrible at these but trying to get better at it. Please help.

=([Current Cost]@row-((([projected # of lines])*50.95) *[remaining project months]@row))

What I am trying to do:

Projected Savings to project end = ([Currrent Cost] minus ([projected # of lines] times 50.95)) then multiply by [remaining projects months]

Is it possible to create one formula to generate the result? Thank you, in advance, for your help.

--Lisa M.

• ✭✭✭✭✭✭
Options

You're just missing an @row for your projected # of lines. Your formula should be:

=[Current cost]@row - (([Projected # of lines]@row * 50.95) * [Remaining project months]@row)

Hope this helps, if you've any questions etc. then just post! 😊

• ✭✭✭✭✭✭
Options

You're just missing an @row for your projected # of lines. Your formula should be:

=[Current cost]@row - (([Projected # of lines]@row * 50.95) * [Remaining project months]@row)

Hope this helps, if you've any questions etc. then just post! 😊

• ✭✭✭✭✭
Options

Hello @Nick Korna

Thank you so much for helping me! The formula works now!

--Lisa M.

• ✭✭✭✭✭✭
Options

No problem, happy to have helped! 😊

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!