Creating formula in smartsheet

Jasmine Hassan
Jasmine Hassan ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

I have a requirement to calculate the remaining shelf life of products at the time of receiving in percentage. 

My formula is: (Production date + Expiry date) / (Expiry date - Delivery date).

The end result should be a percentage.

Can anyone help me to achieve this?

Regards,

Jasmine

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!