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

Mel_B

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?

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?