% Completed and Task Finished

Guy Rousseau

I would like to have the % completed set automatically to 100% when the Task Finished is checked.

Any suggestion on how to do that?  First smartsheet struggles...

 

L_123

=if(*select the cell with the checkbox*,1)

J. Craig Williams

Guy,

If Dependencies are enabled, you can not have a formula in the % Complete column.

If your completion is binary (either 0% or 100%) and dependencies are disabled, then Luke_TK's formula is OK. If you sometimes want to have a different percentage (ie 49%), then as soon as you enter a value, the formula is gone and won't come back.

To handle situations like this I use Zapier (www.zapier.com) or other automation tool (though Zapier is by far my favored solution) or the API (code development)

Here's a similar example I wrote for Zapier - it takes a check box and enters the completion date. I have another version that allows the user to pick one of the three choices - check box "done", enter the completion date, or mark it 100% complete ... Zapier will fill in the other two. I did this because the PM entered the % Complete and the engineers had the check box .... and both wanted to capture the date.

http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/

I hope this helps.

Craig