Forum Discussion

bharker's avatar
bharker
Copper Contributor
Aug 01, 2020
Solved

Need assistance with formulas

Hello all, I needed some assistance with some formulas. Looking for column B starting @ B5 to auto populate with a yes or no depending on the answers in columns D thru I. If they are all yes, then B...
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Aug 01, 2020

    bharker 

    I'm not sure because the translation is not the best ... but here is an example.

    Have a dro down menu built in D, at the same time the formula is built in B.
     
     

    If you find this helpful, please mark it as Like (click thumbs up) and as "Best Answer", it will be beneficial to more Community members reading here.

     

    Nikolino

    I know I don't know anything (Socrates)

bharker's avatar
bharker
Copper Contributor
Aug 01, 2020
This is nice! So right now if D5 is yes then B5 is yes, but I need D5, E5, F5, G5, H5, I5 to also all be "yes" for B5 to be yes. If any of D5, E5, F5,H5, or I5 = no, then B5 = no.
bharker's avatar
bharker
Copper Contributor
Aug 01, 2020
Also, nice job on the drop down boxes in column D. Can E,F,G,H, & I also have these same drop downs?

Resources