I have several columns and i need the priority column to state wether the priority is high, Medium High, Medium, Low based on criteria in several of the other columns.
High
New members
Members with score 5 or higher
Or members that have score less than 5 but are high risk and have a date blank or not in 2019
Medium High
Score 2-4
No 2019 date
Medium
Score 0-1
No 2019 date
Low
score 0
2019 date
Here are the columns with some data
Date Score Risk Status Priority 10/13/2018 9 Y Retained 2/1/2019 4 N NEW 3 Y Retained 1/14/2017 6 N Retained 1/5/2016 12 Y Retained 1 N Retained 8/25/2018 0 N NEW