I have a list of 6 activites. Have set up formulas to give the activity a score of 0,1,2 (meaning Not complete, Pending and Completed). I want to each activity has a different instuction based on not be complete or pending. Here's an example of what I would like to see.


Name Activity 1 Activity 2 Activity 3 Activity 4 Activity 5 Activity 6 Results
Chad 2 2 2 1 0 0 Activity 4 is pending please contact us
Sara 2 2 0 0 0 0 Activity 3 is not complete, please contact us

This is the basic idea of what I am thinking of accomplishing.