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

Unable to change the colours on charts/widgets
Hello Everyone, I have some dashboards created and it seems that since this morning all the charts colour changed colour even though the correct colour is selected: I went to the Smartsheet status page and it seems all status are running normally. Anyone having the same issue? Many thanks Mariana
Automation Not Working – Status Not Updating Automatically
Hi Smartsheet Community, I’ve set up an automation rule in my Smartsheet to automatically change the "Status" column to "New" when a new request is submitted via a form. I followed these steps: Created a "Status" column. Set up an automation rule triggered by "When a row is added." Chose the action "Change cell value" to…
What causes parts of my sheet to flash?
I no sooner changed a date and parts of my sheet started flashing, any idea why?

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