RYG Automation- Checkbox and Date

Jess
Jess
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 

 

 

Comments