Using Multiple Checkboxes to determine and auto-update % Complete

Lizzie Armstrong

I have some tasks for an implementation Smartsheet that require different steps. I would like the % Complete column to auto update to 33%, 67% or 100% based on the boxes checked. Obviously if the final box is check it would be the 100% and ignore the 2 boxes that came before it. I attached a screen shot with the formula I attempted but it does not work. Any ideas? Also not sure if the true result should be 33 or .33 if the entire column is set up in % format.

Paul Newcome

It looks like you are missing an opening parenthesis after your third IF. Once you add that, the values to output should be in decimal format without quotes.

1

.67

.33

0

Lizzie Armstrong

Thank you! I made those changes but it still has the #UNPARSEABLE Error. The exact formula is below. The #BLOCKED in the 'At Risk?' column shouldn't be an issue. It is set to flag if the date is after TODAY and the % is not 1.

=if([Reviewed/Completed]40 = 1,1, if([Data Received/Time Scheduled]40 = 1, .67, if([Sent/Discussed/Requested]40 = 1, .33, 0)))

Paul Newcome

@Lizzie Armstrong My apologies for the delay. I am not sure how the notification for your response got so buried in my emails. Were you able to get this working?