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

Can someone please help me with a COUNTIFS formula?
I can't seem to get this formula to calculate any results other than 0 COUNTIFS({11.08.2024- Labor Allocations for Smartshe ES}, [Expense Specialist]@row, {11.08.2024- Labor Allocations for Smartshe FU}, OR(@cell = "410101", @cell = "41201", @cell = "410202", @cell = "410203". This is only a part of a larger formula.
"Record a Date" Automation to a Cell in a Hidden Column
I have lots of sheets for a reviewing process - each item to review has a new sheet from a template. Each sheet has about 30 rows and a summary sheet. I have an automation that does the following: When "status" cell changes, request an approval. (This is calculated in a summary sheet and written to a cell.) Approval comes…
How to share WorkApps with view only colleagues on an enterprise plan?
Hello! We have an enterprise plan for our company and with 2 licenses on it. I have created a workapp to share some sheets and share a dashboard in one place. Yet I am not sure why I got this message from them when they tried to access it. Could you please help as from my understanding this should be free on the plan we…