Avgerages, assigning a value to text, and parent/child formula


I'm attempting to insert a formula into parent rows that assign a % complete based on entries on child rows. The child rows responses are locked based on task completion. The options are: "Yes, In-Process, and Not Started."

I've made these two stand-alone formulas that I "think" will work, but I can't get them to play nicely.

=IF(Complete@row = "Yes", 1, IF(Complete@row = "In-Process", .5, IF(Complete@row = "Not Started", 0)))


Thanks in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!