Creating formula in smartsheet

Jasmine Hassan · 01/10/19

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

Andrée Starå · 01/10/19

Hi Jasmine,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome · 01/10/19

Try something like this...

=([Production date column]@row + [Expiry date column]@row) / ([Expiry date column]@row - [Delivery date column]@row)

Jasmine Hassan · 01/13/19

Hi Andree,

I managed to solve this. Below is the formula for your information.

=NETDAYS([Date of Supply]1, [Expiry Date]1) / (NETDAYS([Production Date]1, [Expiry Date]1))

Regards,

Jasmine

Jasmine Hassan · 01/13/19

Hi Paul,

I managed to solve this. Below is the formula for your information.

=NETDAYS([Date of Supply]1, [Expiry Date]1) / (NETDAYS([Production Date]1, [Expiry Date]1))

Regards,

Jasmine

Andrée Starå · 01/13/19

Hi Jasmine,

Great to hear that you solved it.

Have a fantastic week!

Best,

Andrée

Paul Newcome · 01/14/19

Excellent. Glad you got it figured out.

Formulas and Functions

Formulas and Functions

Creating formula in smartsheet

Comments

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Is there a way to make a field in a form auto populate street address as its being entered?

IF formula for INDEX/MATCH across sheets

NETDAYS Formula Question