When checkbox is checked harvey ball to show as full

Irene Plant

I am trying to set up a formula using a checkbox and a harvey ball. Basically I would like the harvey ball to show as full when the checkbox is checked. The checkbox column is titled complete, once this is checked the harvey ball should be full. I have tried lots of different formulas and none of them are working the way I would like them to! Any help would be much appreciated! Irene

Christian Wells

Add a Formula to your Harvey Ball Cell...

 

= IF ( [checkbox] = 1  ,  "Full" , "" )

 

If Check box is Checked, then Set cell value to "Full"           Else  Blank