Sign in to join the conversation:
I need help figuring out how to create an overall status using the RYG Balls based off 3 other columns with RYG Balls. Can someone help me? Example is below.
Thank you!
You need to define what you mean by overall status. There are 27 possible combinations of 3 columns of 3 choices. What do they each mean?
Once that is defined, then the formula can be built. That definition will also determine which possible formulas might be among the best ones to use.
Craig
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
