On one side, there are four dropdown columns (Scope, Time, Resources and Budget) that can contain only one the following values: Green, Yellow and Red.
On the other side, I want to make "Project Health" a calculated column with those same options (green, yellow and red) based on the 4 columns above.
The potential cases would be the following:
- If one of the four columns is RED, "Project Health" is RED
- If one of the four columns is YELLOW, "Project Health" is YELLOW
- If all four columns are GREEN, "Project Health" is GREEN.
I am using SharePoint 365.