Need Help, trying to make a conditional drop down, Or something like that

[SyzygyMoi]

Good afternoon all!
Thanks in advance!
I am trying to make the spreadsheet attached work in the following way.

I enter the name of the person from a drop down menu, COLUMN A.
In COLUMN B, I want to choose if the task is WOODWORKING or METALWORKING.
If I choose WOODWORKING in COLUMN B, I want, I COLUMN C for the tasks the Woodworking task drop down menu from DROP DOWN sheet to appear in COLUMN C. If It is a Metalworking task I'd like it to be the Metalworking Dropdown from the DROP DOWN Sheet.
Then, depending on what was chosen, the Total time spent on the task appears in the correct column.

Is this doable?

Thanks so much!

Marek

[menem]

Yes, it's doable.

By create name range in "Drop Down" sheet as the same of B column.
Then use validation via function INDIRECT()


Regards.

[Gregb11]

Then to answer your other question, you can enter this in cell H2
=IF($B2="Woodworking",$G2-$F2,"")
and in I2
=IF($B2="Metalworking",G2-F2,"")
and copy both down.

[SyzygyMoi]

THANK YOU SO MUCH! It all worked! You all are helping and teaching me so much!

Marek

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[SyzygyMoi]

Thank you! It works, learning a lot and appreciate your help and teachings!

[SyzygyMoi]

Thank you so much! I see what you did now, I see where you put the INDIRECT() function in the DATA VALIDATION. Thanks! When I put it in my full spreadsheet, I've attached it, I seem to get an error. The TASK TYPE Column does not work. When you put in the INDIRECT() into the DATA VALIDATION, how does it reference the correct DROP DOWN? I see you added a black Cell above and below the data in the DROP DOWN section, what does this do? I searched for any added function in those cells and the entire range and could not find anything.
Thanks!

[SyzygyMoi]

I figured it out, it was a problem with the naming of the drop-downs and my task choices! Thanks again, Greb11!