Formula to Update Status based on Percent Complete (Column Formula with Row Heirarchy)

Please see pic. I am using this formula. How do I update it to work as a column formula and also recognize parent/child row hierarchy, please?

IF([% Complete]1 = 0, "Not Started", IF([% Complete]1 = 1, "Complete", "In Progress"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!