Sign in to join the conversation:
I would like to have the parent row of my health column automatically be red, green or yellow based on the average health of it's child rows.
Does anyone have an idea of how to accomplish this?
What do you mean by "average"? Do you mean the majority of colors determine the parent or are you looking more for a "scoring" type of thing where each color is given a number, those numbers are averaged together, and then that determines the Parent Row color?
My algorithm to achieve this - for columns, not child rows - lookslike this:
=IF(COUNTIF(Schedule1:Quality1, "Gray") + COUNTIF(Schedule1:Quality1, "Green") = 4, "Green", IF(COUNTIF(Schedule1:Quality1, "Red") > 0, "Red", "Yellow"))
You would probably have to do some nested IF and COUNTF formulas to achieve something similar for child rows, maybe even combined with some fractions like COUNTIF/COUNT to trigger the correct result from the IF statements.
Hello, In my source sheet I have a multiselect column called "Problem Code to be Updated". I am trying to use the reference sheet in the screenshot to identify if the multiselect cell in the source sheet has any of the problem codes where the "Technician Assigned Problem Code" is "Yes". The dropdown values are all taken…
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
