Checkbox to equal 100% in % complete

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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%")


  • Found my error


    The formula should have been


    =IF(Completed4 = "true", "100%"

  • Here is another option. 

    =IF([email protected] = 1, 1)

    You will need to format your % complete column as a % but then it will load the actual % rather than text. 

Sign In or Register to comment.