RYG IF Statement Help
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!