Checkbox to equal 100% in % complete

chicago25624

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

chicago25624

Found my error

 

The formula should have been

 

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

Nic Larsen

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. 

Nick Rozaklis

What if there are multiple status' that equal 100%? what would the formula be for that?