# Creating formula in smartsheet

✭✭✭✭
edited 12/09/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

Tags:

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

Try something like this...

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

• ✭✭✭✭

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

• ✭✭✭✭

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

• ✭✭✭✭✭✭

Hi Jasmine,

Great to hear that you solved it.

Have a fantastic week!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

Excellent. Glad you got it figured out.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!