I have a multiple choice field called TIER with the options of Gold, Silver, and Bronze. I have a formula duration field called "RECOVERY." I want to use "RECOVERY" as minutes. I want to push yes or no to another field called "MET SLA" if certain conditions are met. If the none of the conditions are met, then I want to leave MET SLA blank. For example:
If TIER='Gold' and RECOVERY<=60 then MET SLA='Yes'
If TIER='Gold' and RECOVERY>60 then MET SLA='No'
if TIER='Silver' and RECOVERY<=120 then MET SLA='Yes'
if TIER='Silver' and RECOVERY>120 then MET SLA='No'
Else MET SLA=null