Nested IF Statement based on Four Status Ball columns

System

This discussion was created from comments split from: Issue applying conditional formatting to a symbols drop down.

ShariM

How would I write this formula based on needing four columns to be a certain color symbol?

Once columns 2 - 4 change green, I would like the first column to automatically turn green.

Thanks for any help!

Genevieve P.

Hi @ShariM

This looks like a duplicate post to your other question:

https://community.smartsheet.com/discussion/65937/nested-if-and-but-need-and-and-or#latest

Your other post seems to have more information so I will answer you there.

Thanks!

Genevieve