Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
Hi All, I'm working on a formula that is evaluating three columns of data: 1) EOY Target Weighted MWh 2) Forecast Weighted MWh 3) Increase/Decrease (to determine if the goal for the year is to increase or decrease the MWh) Here is my current formula: =IF([Forecast Weighted MWh]@row = [EOY Target Weighted MWh]@row, "On…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…
