Creating Expiration dates based on products

mtenn

I want to create a formula that will auto-generate expiration dates for individual products for an entire column. The sheet has a created date and column containing a dropdown list of products. The products have different expiration dates. Ideally I would like to format the expiration date column to have the product (Buffer name) + creation date (date filled) + # of days = expiration date. After formatting the user can enter any product from the dropdown and the expiration will autofill. Is this even possible?

kowal

Hi @mtenn,

But if you put the "buffer name" into a column that should have a date only it will not be date anymore.

The expiration date (if you want smartsheet to recognize it as a date) should be only pure date in a date format.