Complete/Not Complete Dots Formula for multiple rows

I am wondering if there is a way to create a formula in a cell that will tell you if the following 10-30 cells say complete. For example, when working on a project if all of the tasks beneath are "Green" or marked as "Complete", is there a way to have the top cell also say "Complete" only if all of the tasks also are? Or, if one of them is still "In Progress", the top cell will say "Not Complete" or show a "Yellow" dot? And if they all say "Not Started" have the top cell also say "Not Started" or show a "Red" dot? Let me know if anyone has any insight on how to do this. Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!