Help with Vlookup + date

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)

Find more posts tagged with

Manufacturing

Finance

Formulas

Cell linking

Account and User Management

Comments

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)

Captura de Pantalla 2019-09-06 a la(s) 11.38.08.png

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)

Captura de Pantalla 2019-09-11 a la(s) 07.11.26.png

Sign in to join the conversation!

Quick Links

Trending discussions

SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…
Prevent due dates from falling within the same calendar week?
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…