2

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

Functionality
Industry
Department

Comments

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.