Help with Vlookup + date

Gerardo_Clarke

I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be made up of the date Issue + 30 days.

For this I thought it was viable to use Vlookup by referencing a sheet with the types of payments available in our accounts.

I hope you can help me. Thank you.

(I leave images for review)

Connor Hartford

You need to add to the date.  Try the following formula in the 'Expiration Date' column.

=[Invoice Date]@row + Vlookup([Payment Types]@row,{Payment type days},2)

Gerardo_Clarke

Hi Connor, 

I tried to do it as you suggest, but it doesn't work. (thank you anyway)

Embedding in row 17

(attached image)

Connor Hartford

It looks like the reference you showed in the first post had {Payment types days}.  I put {Payment type days} in my formula.

Try to add the 's' on there and see if it fixes the reference.

Gerardo_Clarke

Sorry, but it doesn't work even if I changed as suggested.

I was reading similar posts and LOOKING (I am not 100% sure) Smartsheet would not have the option to reference conditional drop-down lists from another sheet.

Yes it can be referenced by associating "filters" from another sheet, but not from the drop-down menu.

thanks for your help. (image of what was done)