RYG IF Statement Help

edited 12/09/19 in Smartsheet Basics

Hello-I am working to automate a SmartSheet for my team and have a "Status" column with RYGs (Red, Yellow, Green) which are visual assists for the status of the action item.  I need help; the IF statement I created won't work.

Here is what I need:

IF the "Completed" column (based on a date entry) is populated with a date, the RYG should turn green.  IF the "Scheduled" column has a date, the RYG should turn yellow.  Otherwise, the RYG will be Red if both the "Completed" and "Scheduled" columns are blank.

Hoping you can help-thanks so much!