Posts by lizzybug0802

  • If Formula with multiple columns

    I"m a little stuck. I've built a ton of formulas in the past but I can't seem to get this one to work the way I want. I've been working with the below categories and trying to create a specific if formula that returns the needed value. In this case if the value in the casual column is Y and the value in the non casual column is N then i need the formula to return Y but if the value in the casual column is Y and the value in the non casual column is Y then i need the formula to return N. Any help is appreciated! I've added some sample data below.
    [TABLE="width: 182"]

    [tr]


    [td]

    Casual

    [/td]


    [td]

    Noncasual

    [/td]


    [td]

    Is user only casual?

    [/td]


    [/tr]


    [tr]


    [td]

    Y

    [/td]


    [td]

    Y

    [/td]


    [td]

    N

    [/td]


    [/tr]


    [tr]


    [td]

    N

    [/td]


    [td]

    Y

    [/td]


    [td]

    N

    [/td]


    [/tr]


    [tr]


    [td]

    Y

    [/td]


    [td]

    N

    [/td]


    [td]

    Y

    [/td]


    [/tr]


    [tr]


    [td]

    N

    [/td]


    [td]

    N

    [/td]


    [td]

    Y

    [/td]


    [/tr]


    [/TABLE]

  • Populate form using data from reference sheet using drop list filters

    Hi all,
    I am attempting to create an automated OSHA log for my company which populates information based upon a drop list. The information is all being added from a data dump from another software program so the information is provided as needed but I need to be able to sort and populate the format by facility and full company. I've attached a copy of what I'm trying to achieve. I can very easily get the full company one but sorting by facility isn't working well as the closest I can get in formatting provides me only the first record for that facility rather than all the needed records. In the attachment is an example of how the data is pulled currently without any filtering, what Im trying to accomplish is that the records in the table reflect the selection in drop list on the first tab. Any assistance would be greatly appreciated!forum.ozgrid.com/index.php?attachment/60136/