Future Value Formula

Cindy Mahama

Cindy Mahama ✭✭

09/01/23 in Smartsheet Basics

How would I create a FV formula in Smartsheet similar to the formula in Excel?

0 ·

Answers

SteyJ ✭✭✭✭✭✭

09/03/23

Does this work?

=[Present Value]@row * ((1 + [Interest Rate]@row) ^ [Years Compounding]@row)
Hope this helps,

Sincerely,
Jacob Stey
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Export to PDF
Hello, Is export selected rows to PDF disabled? thanks
Workflow Subscription
Hello, I have someone who unsubscribed from the automation workflow notification and now needs to be added back. How can this be done? Thanks!
Parent and child rows
Hello, I need assistance with managing parent and child rows in Smartsheet. How can I display a milestone as completed once all of its child rows are marked as 100% complete? For example, if I complete all the rows under Milestone 5, how can I set Milestone 5 to show 100%? Thank you in advance for your help.

Help shape the future of Smartsheet.
Share your ideas and feature requests.