Formula to automatically check the checkbox in a "complete" column

I'm using RYGG balls to indicate the status of a row. Grey represents complete as a colour. When a cell is changed to grey in the status column, I'd like for the checkbox in the "complete" column to automatically be checked.

What formula would I create to complete this task?

Find more posts tagged with

Account and User Management

Comments

Travis

Hi Mel_B!

An IF statement can do this for you. Try this:

=IF(RYGG1 = "Gray", 1)

Replace RYGG1 with the cell you want to reference.

Here's a link to our Help Center article on formulas with more information: http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas

arodney

Hi Travis. I tried the following formula to have a box checked if a Completion % is manually entered as 100:

=IF([Completion %]183 = "100%", 1)

Though the formula returns no error, it also does not returned a checked box. This seems fairly simple, what am I missing?

Thanks!

CallmeQ

I'm having the same issue as arodney. Any solutions out there?

Elizabeth Hernandez

arodney, I believe you have to type to "100%" in as "1" or "0.5" if "50%". Basically using decimal instead of percentage form. Give it a try, I hope this works for you.

safisam

Thank you @Elizabeth that worked

Steve Fogel

This works.

Gwen_G

Why does the formula =IF([Completion %]=1,1) not work for me? I continue to get unparsable. I want to auto check the complete checkbox when my %complete is 100%. Can someone help me with the formula?