Formula to calculate remaining savings to end of project
![Lisa Matthews](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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.
Best Answer
-
Hi @Lisa Matthews,
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! 😊
Answers
-
Hi @Lisa Matthews,
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! 😊
-
-
No problem, happy to have helped! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!