Checkbox to equal 100% in % complete

chicago25624 · 06/03/19

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 · 06/03/19

Found my error

The formula should have been

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

Nic Larsen · 06/03/19

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 · 08/07/20

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

Comments