Require Cells to have scroll down category based on other filled cells

    Re: Require Cells to have scroll down category based on other filled cells


    Take a look at this link at Contextures


    Create Dependent Drop Down List


    This is a commonly asked question and there are plenty of posts on the forum.
    Do a search using Dependent Data Validation or Dependent Lists as the search terms.

    Re: Require Cells to have scroll down category based on other filled cells


    Thanks but I still cannot find it. The problem is that they are logging their hours on the timesheet but not using the drop down in the category column and I cannot figure out how to make that drop down selection a requirement. Then the hours are not logged in the proper category for the payroll admin.

    [ATTACH=CONFIG]70900[/ATTACH]

    Re: Require Cells to have scroll down category based on other filled cells


    OK - reread your post, understand now what you need, You want to lock out the drop down selection until after time entries are made.


    Let's say the time entries are made cells B2 (in) and C2 (out).


    If cell A2 contains the data validation drop down list, we could use this formula to lock out the list if time entries are not made
    Here is the formula:


    =IF(AND(ISNUMBER(B2),ISNUMBER(C2))=TRUE,INDIRECT("List"),"")


    In the formula "List" is the named range containing the list of selections for the category drop down.


    Obviously, you must adjust the cell references and change "List" to the actual named range.

    Re: Require Cells to have scroll down category based on other filled cells


    Thanks but that is not it either. I am needing to REQUIRE the drop down list option IF they have filled out the time.


    (This is so the accounting admin knows how to categorize the work without having to look up the person individually to know the work code.)

    Re: Require Cells to have scroll down category based on other filled cells


    Quote

    I am needing to REQUIRE the drop down list option IF they have filled out the time.


    The method I provided will only show the drop down list if both time entries are made. To be clear: no time entries, no drop down list.
    How does this approach not fit your described need?


    I did forget to mention that you must use Data Validation > Custom option for this method to work.
    Perhaps you did not implement it correctly due to that oversight.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login