Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Changing the ball color on parent based on color of children

Jeff Smith

Jeff Smith ✭

01/18/16 edited 12/09/19 in Archived 2016 Posts

What I am trying to do is change the color of the RYG ball to red if any of the children have a red ball else leave it blank.

Tags:

0 ·

Comments

Jeff Smith ✭

01/18/16

I was able to figure this out on my own. =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", "")

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

How to count a field which has a certain character in it.
I have a field with the date formatted as 09/30/2024. I would like to summarize that field with the count of lines containing 09 and 2024 (so basically by the month and year). I am attempting just for the month and can not get it to work. =COUNTIFS([Next Renewal Date]:[Next Renewal Date], CONTAINS("09") But I would also…
Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…