I am trying to set up an at IF statement -

Storr 1

if a box is checked, then enter 100% in the %Completed column??

Jason Duryea

The formula would have to go in the % Complete column, which would prevent someone from manually entering any other % in the cell.

To avoid this, setup an automation to change a cell value when the checkbox is checked instead.

Jason Duryea

The formula would have to go in the % Complete column, which would prevent someone from manually entering any other % in the cell.

To avoid this, setup an automation to change a cell value when the checkbox is checked instead.

Storr 1

Thanks a bunch - real easy