Hi all,
I have this below requirement
I have a variable called 'Team'. I want to make the color of the field to be updated in list view, based on the consolidated values of the other variables,
Variables
Team
Sub team(Sub Team1,Sub Team2,Sub team3,Sub team4)
Month
Metric 1 (Red,Green,Amber)
Metric 2(Red,Green,Amber)
Metric 3(Red, Green,Amber)
Condition 1) Each Sub team under the subteam will be submitting an individual request filling 3 metrics
Condition2) If All Sub Teams, submit All 3 metrics as Green, Then the field Team should be color coded as Green in list view
Condition 3) If anyone of the Sub team submits, any of the metric as Amber or Red, then the Team field should be color coded as Amber
| | Output | Responses | | | |
| Month | Team | Sub Team | Metric1 | Metric2 | Metric3 |
| Jan | Infra | Wintel | Green | Green | Green |
| | | Unix | Green | Green | Green |
| | | Storage | Green | Green | Green |
| | | Database | Green | Green | Green |
| | | | | | |
| | Output | Responses | | | |
| Month | Team | Sub Team | Metric1 | Metric2 | Metric3 |
| Jan | Infra | Wintel | Green | Green | Green |
| | | Unix | Green | Green | Green |
| | | Storage | Amber | Green | Green |
| | | Database | Green | Green | Green |
@Ankur Bawiskar @Community Alums
