Mar 13, 2019

Assignment Tracker template drop down not all inclusive

Using the " Assignment Tracker" template, not all of the "subjects" appear in my drop downs. Only 10 or so appear.
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
Mar 13, 2019
Hello,
 
You may have to redo the "Data Validation" and make sure the range it uses from the "Subjects" sheet is set to the whole column like...
 
Subjects!B5:B
 
...currently it is only set to B5:B20 so any new subjects after B20 will not show in the drop-down list.
 
 
James :)
Original Poster Erik Bosiljevac marked this as an answer
Helpful?
All Replies (2)
Recommended Answer
Mar 13, 2019
Hello,
 
You may have to redo the "Data Validation" and make sure the range it uses from the "Subjects" sheet is set to the whole column like...
 
Subjects!B5:B
 
...currently it is only set to B5:B20 so any new subjects after B20 will not show in the drop-down list.
 
 
James :)
Original Poster Erik Bosiljevac marked this as an answer
Mar 13, 2019
Is there a way to add a dependent drop down menu? I am trying to create a menu that if option 1 is chosen, drop down 1 is presented, likewise with option 2-10
false
6730854337570388438
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false