auto tick box checked dependent on all dots green

rob.begley ✭✭
edited 12/09/19 in Smartsheet Basics

Hi I have several columns when once all green dots turns the row green, done with conditional formatting, however I have a column with a check box and want a formula that automatically ticks the checkbox once all dots in row are green, please can someone help?