Checkbox to equal 100% in % complete


I am attempting to do the following.

If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100%


Here is the formula I thought would work using task 4.of the project.

=IF(Completed4 = "Complete", "100%")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!