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...
=if(*select the cell with the checkbox*,1)
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
