RYG Automation- Checkbox and Date

edited 12/09/19 in Smartsheet Basics

HI guys,


I am quite new to SS and need a tad bit of help


I need a formula that will check to see if a checkbox is completed from another sheet as well as it is on today date it will turn the RYG ball green, if the checkbox is checked and not on the right date it will turn Red


Please help