Future Value Formula

Options

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 Community Champion

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

What is the difference between a workspace and a sheet?
I have noticed that we can no longer just create a sheet.
I have given admin access to 2 users but they cant access locked cells. am i missing something?
Hi everyone, this is the first time i have needed to post a question. i have been using Smartsheet for about a year and have developed the environment to suit our business quite easily, now i have it running i have set up all of the users (previously everyone was using the 1 login while i set it up). However now i have an…
Certification Quiz Wrong Anser
Hello, I have a strange question. I just completed the core product prep quiz, and the answers that we given on a couple of my wrong answers were either wrong, or partially wrong. Who would I forward this information to? Thanks!

woman with hands out and open

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

Watch video<