Percentage based on "Complete"


Hello! I have a column labeled "Line Status" with many different statuses. One status is "complete" and I would like to produce a percentage based on the # of times complete exists compared to the number of lines with any status at all. Each line is a step in our process, and as we mark each line complete I would like it to show what percentage of all lines are complete - Thank you for any help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!