ContributionsMost RecentMost LikesSolutionsRe: Creating 'status' based on numeric number Worked - thanks so much! ------------------------------ Michael Stromberg ------------------------------ Creating 'status' based on numeric number I am trying to create a status column, based on a numeric field "Total number of sales'. We have 5 different catogires, within last 30 day. Try to based on total number of sales field (last 30 day totals are already pulled), assign a status from below. <!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}--> Champion 8+ Avid 6-7 Average 3-5 At Risk 1-2 Lapsed 0 ------------------------------ Michael Stromberg ------------------------------