Forum Discussion

Astro2023's avatar
Astro2023
Copper Contributor
May 30, 2023

Trying to add a function to multiple tables with drop down menus

Hi! I am trying to add a function on multiple tables with drop-down menus that will make sure I don't input the same option in the same spot on the table.   For example, if I place Gym 1-2 Monday ...
excel
mathetes's avatar
mathetes
Gold Contributor
May 30, 2023
Presumably you already have created a workbook where you want to create this functionality. It would help us help you if you were to post a copy of that actual workbook (not an image; an actual Excel workbook). If it contains confidential or private information, then replace that with fictitious names or in some way alter it so it's anonymous). Post that sample workbook on OneDrive or GoogleDrive with a link pasted here that grants edit access to it.
Astro2023's avatar
Astro2023
Copper Contributor
May 30, 2023

mathetes  Hey ! Here is a link to google drive with a copy of the excel file

https://docs.google.com/spreadsheets/d/1IgbiQhkVmU4Su5o4kD0AirYI8qvJgsc4/edit?usp=sharing&ouid=116265735144766116399&rtpof=true&sd=true

 

Need to have every monday first period look at the other tables to see if theres a duplicate, if theres a duplicate, to place each "error" cell red to tell me theres something that doesn't work.

 

So B4;I6;P4;W4;AD4;AK4;B19;I19;P19;W19;AD19;B34;I34;P34;W34;AD34;AK34;B49;I49;P49;W49;AD49 are all the cells for Monday first period.

  • mathetes's avatar
    mathetes
    Gold Contributor
    May 31, 2023

    Astro2023 

     

    I understand what you've asked for--that you want the cells for any given period on any given day to NOT show the same activity, so if they do, you want it to show in Red.

     

    What I don't understand is why. It seems backward. Just to look at the GoogleSheet sample, it would seem you desire having the same activity in the same period each time; i.e., that the error would be if something else were to be entered. So maybe I don't understand what this spreadsheet is supposed to be doing in the first place: it looks as if you are scheduling activities or classes or _________, where, again, it would seem to make sense that the same activity often (if not always) be repeated in the same period on a Monday (or whatever).

     

    So could you explain more fully what the bigger picture is here? 

     

    Quite frankly, it looks to me as if you're also using Excel largely for it's rows and columns, and not in general for any calculations or anything really using computer power -- with the possible exception of highlighting what you're calling an error. That's fine, but .... well, as noted, I'd appreciate a more complete description of what this is to be used for, how entries will be made, what will the output be, etc.

    • Astro2023's avatar
      Astro2023
      Copper Contributor
      May 31, 2023
      I'm available if you are to hop in a discord call and give more details and maybe a clearer explanation. Having a tool like this would make it a LOT easier for me as I am currently doing it manually with physical paper and such 😕
    • Astro2023's avatar
      Astro2023
      Copper Contributor
      May 31, 2023
      Hey, so what I'm trying to do is a schedule for 23 different groups.
      Each table on the sample sheet I shared is for 1 week. Meaning, I DONT want the same activity in the same period of each time.
      For example, if group A has gym 1-2 during the first period on Monday, group B CANT have gym 1-2, that's why, if that happens, I placed both groups doing the same activity at the same time of day, I want it to appear as RED so that I can see that there's an overlap and I need to fix it.

Resources