Future Date Calculation

Mandi
Mandi
edited 12/09/19 in Formulas and Functions

Hi 

I'm trying to convert an Excel formula to Smartsheet formula:

Excel formula =[Installation date]4+(365*[Warranty Expiry]$3)

Aim is to give a future date when the warranty will expire x years after the piece was installed.

 

Thanks 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!