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

Locking a Tab in the desktop app to a Dashboard
I have a dashboard that has links to all my Smartsheet's. It includes ToDo list for my team, system documentation and much more. The issue is I will go to my Dashboard and click on a link but then now my Dashboard is no longer open. Is there a way to lock a Dashboard to a tab or force the link to open in a new tab so my…
WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Controlling Asset Permission Levels
I have a feeling the answer is NO, but wanted to confirm. We are considering upgrading our Enterprise plan, but need to consider the significant price increase if we upgrade, so we are looking to cost structure variations based on what our users are doing in Smartsheet. We want to control the assets being shared not only…

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