Formula in Percentage Complete Column


I am trying to create a formula that if the status column is "complete", the percentage complete column = 100%. The cell won't take the formula. Is this not possible or am I doing something wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!