Present Value Formula?

Erin Maxey

Is there a PV formula in Smartsheet similar to Excel?

I'm looking to calculate the loan amount when I know the term, rate and payment amount.

Bassam Khalil

Hi @Erin Maxey

Hope you are fine, Unfortunately, this feature is not currently available. You can submit a Smartsheet Product Enhancement Requests using this form. 

but you can do it using helper columns and the related formula to calculate each factor used in PV function that you use in Excel. also, you can check the smartsheet solutions center you will find many useful templates that you can use to start designing your applications. 

JCardinal

Hi @Erin Maxey,

Were you able to create a solution for this? If so, I'd love to know more as I'm looking to set up this calculation in Smartsheet.

Thanks,

JCardinal

@Erin Maxey,

With the help of ChatGPT I found that the first part (before the "+ IF") of this formula works for me: