If statment with labels

[Ande1324]

Hey,

I am trying to use three if statements to decide which label to use.

I am reeding out of one excel column, in this excel column there are three key words NO, OK, and Ongoing. I want to use the if statement to differ between the three key words. For example I want No to be Red, Ongoing to be yellow and green to be ok.

RED: if(contains(‘items(‘List’)?[‘Class Status’]’, ’NO’), ‘Yes’, ‘No’)

Yellow: if(contains(‘items(‘List’)?[‘Class Status’]’, ’Ongoing’), ‘Yes’, ‘No’)

Green: if(contains(‘items(‘List’)?[‘Class Status’]’, ’OK’), ‘Yes’, ‘No’)

The column is named ‘Class Status’ and the Apply to each controller is named List.

I am hoping to be using this block and write the is statements in hear:)

Can one of you help me fix the statements or help me find a better way to do it?