Checkbox to equal 100% in % complete
Options
Comments

Found my error
The formula should have been
=IF(Completed4 = "true", "100%"

Here is another option.
=IF(Completed@row = 1, 1)
You will need to format your % complete column as a % but then it will load the actual % rather than text.

What if there are multiple status' that equal 100%? what would the formula be for that?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!