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.
Bookmarks