Weighted Check box's

Alex Klingbeil

Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this.

i would like if Step 1 is Check Step Percent would %20

If Step 1 and Step 2 is Checked it would = 75 %

if Step 1,2,3 are Checked it would = 95%

if step 1,2,3,4 are Checked it would = 100%

just looking to see if someone has a better idea over writing out a long If Statement.

Jonathan Denis

Hello,

I'm kind of confuse, because on your provided Screenshot, I see text, numbers and checkbox for the same column (Step 1, Step 2, Step 3 and Step 4)… What do you actually want to see?

Couple things can be done, but overall the efficiency gained is really low… You will always need to tell to smartsheet your wanted conditions.

Reading your comments, it looks like higher steps cannot be completed before previous step are done.

So by this logic, I would only look at the highest steps first.

= IF([Step 4]@row=1; 1; IF([Step 3]@row=1; 0.95; IF([Step 2]@row=1; 0.75; IF([Step 1]@row=1; 0.2; 0))))

Now if you want to strenghten your project plan by preventing checking higher steps without completing the previous steps, I would recommand:

1. Conditionnal formatting to visually highlight the problem;
2. Automation: When higher steps are check, smartsheet automatically re-check the lower steps to ensure redundancy;
3. Automation: Locking the line once step 4 is check to avoid mistakes.

If you want your cell to show a error message, then you must code it in the formula.

Hope it helps!

Jonathan D.

Jonathan Denis

Hello,

I'm kind of confuse, because on your provided Screenshot, I see text, numbers and checkbox for the same column (Step 1, Step 2, Step 3 and Step 4)… What do you actually want to see?

Couple things can be done, but overall the efficiency gained is really low… You will always need to tell to smartsheet your wanted conditions.

Reading your comments, it looks like higher steps cannot be completed before previous step are done.

So by this logic, I would only look at the highest steps first.

= IF([Step 4]@row=1; 1; IF([Step 3]@row=1; 0.95; IF([Step 2]@row=1; 0.75; IF([Step 1]@row=1; 0.2; 0))))

Now if you want to strenghten your project plan by preventing checking higher steps without completing the previous steps, I would recommand:

1. Conditionnal formatting to visually highlight the problem;
2. Automation: When higher steps are check, smartsheet automatically re-check the lower steps to ensure redundancy;
3. Automation: Locking the line once step 4 is check to avoid mistakes.

If you want your cell to show a error message, then you must code it in the formula.

Hope it helps!

Jonathan D.

Alex Klingbeil

Thank you this worked out great. i also Added the Automation and Locked Rows great Idea