+ Reply to Thread
Results 1 to 2 of 2

Google’s Sheet with multiple interlinked conditional drop downs

  1. #1
    Registered User
    Join Date
    11-14-2020
    Location
    Brampton
    MS-Off Ver
    Google sheets
    Posts
    1

    Google’s Sheet with multiple interlinked conditional drop downs

    Hi all

    Thanks for taking the time to read this thread - trying to work my head around how to explain my query (but it is based on google sheets, so hopefully the majority of functionally can carry over)

    So... first off the concept of the sheet is a personal training programming sheet that I can use to create in depth programs with multiple variables. The structure of the sheet would be based on having a number of other pages of data interlinked (possibly other spreadsheets too). Each sheet has a different set of exercises and they might be separated based on muscle group or type of movement, eg. 1 data page contains barbells lifts such as squat, bench, deadlift overhead press etc and each of these headings have their own columns with variations of that exercise. Whilst Another sheet has body weight movements for example. Essentially each page becomes a library of exercises which I can then select in a drop down on the main page.

    So am little bit stuck as to what function or format to use -

    I would like it so that in a drop down box in the “Type” column I select a movement (from of any of the data sets across multiple pages) - and the variation column then gives me a number of variables that are included in that data set.

    ie want to create a drop down list in the column called “type” - select squat - it then populates a drop down in the next column called “variation” - which gives me a drop down which is limited to the exercises in that data set for example “front squat” (again bearing in mind there are multiple sheets and data sets) - I am aware that there is the named range function in sheets but I’m not sure if this can play a role here.

    Will this end up being a a long formula “if statement”or is there some function I can use here.

    Hopefully that explains the problem well enough

    Cheers

    Simon

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,816

    Re: Google’s Sheet with multiple interlinked conditional drop downs

    Hello Sizemon and Welcome to Excel Forum.
    It may be easier for someone to help if there was a sample .xlsx file that illustrates the set up of the data is being used to produce the drop down, instructions are given in the banner at the top of the page.
    I don't know much about google sheets, however in Excel it would be difficult to produce a drop down based on values that placed in different sheets. I would suggest to an Excel user to put all of the data that will be used for producing drop downs on a single sheet.
    A search for "excel personal training template" brings up over 23M results so that might be a starting point for thinking about ways to accomplish the goal.
    Let us know if you have any questions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating multiple drop-downs based on primary drop-down selected
    By dcwan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2020, 06:13 PM
  2. VBA to auto clear multiple drop downs in single sheet
    By hvh_1905 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2017, 04:25 AM
  3. [SOLVED] Drop Downs conditional on drop downs
    By BillTD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-06-2015, 09:40 AM
  4. Using Selenium and Drop downs in Google Finance
    By JKlem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2014, 09:07 PM
  5. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  6. Conditional Drop Downs
    By Tim_1 in forum Excel General
    Replies: 3
    Last Post: 05-07-2010, 03:12 AM
  7. Drop Downs and Conditional formulas
    By dre in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2007, 09:01 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1