Hello all. My question is in regards to a column of drop downs of yes or no.

Currently I am able to do for no perfectly. But for “yes” they only success i have had so far is if one dropdown is yes, then the cell i need turns green.

(Separate cell turns green or red)

My end goal is to have a dropdown list that doesnt turn completely green unless all dropdown yes have been completed.

so far i have tried using =countif(range, CONTAINS(“yes” or “all dropdowns yes”))

IdK if its a formula or wording issue.

thanks in advance


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!