Excel drop down lists

Question

Hello-How do I create a formula for sequential dates in a drop down list?For example:&nbsp; I would like to be able to click the drop-down to pick Thursday, August 17, Friday, August 18, Saturday, August 19, etc.&nbsp;I thought it would look something like this but, I can't seem to make it work:=TODAY()+1, =TODAY()+2, =TODAY()+3, and so on.&nbsp;Also, is there a way to enter a job number from our service software in the spreadsheet and have it pull the specific service address into a certain cell in the same spreadsheet?&nbsp;I am trying to use the spreadsheet as a template in an email for our technicians to fill out cohesively.&nbsp; My goal is to have the spreadsheet set up with specific drop downs to choose from and then have it automatically be sent to a select group of recipients.&nbsp;&nbsp;Any help would be appreciated!

patrick2788 · Answer

Chanda1625&nbsp;The data validation won't accept a dynamic array but you can refer to a spill in the sheet containing the dates.&nbsp;This formula produces an array of 30 dates starting from today:&nbsp;&nbsp;=SEQUENCE(30,,TODAY())&nbsp;&nbsp;Place it somewhere in the sheet. Then in data validation, refer to the spill:&nbsp;

chanda1625 · Answer

Thank you very much for your help! I am still a bit confused what goes in the parenthesis after SEQUENCE. Let's say I want today's date to auto-fill in cell A1. Then in C1 I want the drop down that lists 30 days sequentially from today's date. How does that formula look EXACTLY for putting in the data validation.

I am getting stuck on what the last entry is supposed to be. I think it should look like : =SEQUENCE(30, right here should be column, then this should be the word TODAY for start, then here it is asking for step)

What does it want for column? Location, quantity, or what? Also, what is step that it is asking for? Commas between everything? My brain feels like it is going to explode. lol

peiyezhu · Answer

right here should be column,what kind of columns ?here as source of validation,I guess only require 1 column rather than multiple columns.Do you need pick one data and fill several columns (e.g. Location quantity) at once?I guess you can use xlookup formula to fill other column instead.

snowman55 · Answer

Chanda1625&nbsp;Sometimes Microsoft's documentation is not up to the task, as with the SEQUENCE function.&nbsp; I recommend checking another source, such as this Ablebits article., that gives more information; that article is explicit in identifying the columns&nbsp;and step arguments as optional quantities, each with a default of 1.&nbsp;Yes, you need to use a comma between each argument.&nbsp; And note that TODAY is not (just a) word, it is the name of a function, and function names are followed by an open parenthesis, etc.&nbsp;So these formulas are equivalent:=SEQUENCE(30,,TODAY())
=SEQUENCE(30,1,TODAY())
=SEQUENCE(30,1,TODAY(),1)
=SEQUENCE(30,,TODAY(),1)&nbsp;

patrick2788 · Answer

Chanda1625&nbsp;You can use function arguments to aid in construction of the formula.&nbsp;If you enter =SEQUENCE(&nbsp; &nbsp;then press Shift+F3 (or click the Fx button) then you'll get this menu:&nbsp;&nbsp;

Forum Discussion

Excel drop down lists

Share

Resources