Welcome!

If statements with multiple conditions

I have a project status column that uses the circular colored symbols . There are indented rows with symbols and I want the parent row to have a green circle if all of the indented rows have green symbols. If there is at least one yellow circle, I want the parent circle to be yellow. If there is at least one red symbol, I want the parent symbol to be red. Any help would be appreciated.

Find more posts tagged with

Comments

sean59916

Hi Ireland -

Can you clarify what you would expect to see at the parent row if you have 3 children - one is green, yellow, red. Are you expecting a yellow or red parent icon?

Sean

Ireland Adgate

Yes, sorry for the confusion. Red is the most severe and would make the parent red. The parent would be yellow if any of the children are yellow AND none of them are red.

Andrée Starå

Hi Ireland,

Try something like this.

Place the formula below in the Parent of the Status column.

=IF(COUNTIF(CHILDREN(); "Green") = COUNT(CHILDREN()); "Green"; IF(COUNTIF(CHILDREN(); "Red") > 0; "Red"; "Yellow"))

The same version but with the below changes for your and others convenience.

=IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", "Yellow"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Need Help w/ Report View - Nothing Is Showing
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…