Conditional column formula that updates another column


I am trying to create a condition that if the status column is complete mark % complete column to 100% if in progress mark 50% and if not started 0%. Is there a way to do this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!