6 answers
Hey there, try creating this calc:
IFNULL(LOOKUP(MAX([Student Course Completion Status]),0),'Not Started')
And dragging it on in place of [Student Course Completion Status].
Unfortunately I can't use your workbook as it's a TWB with live data source. You need to right click your data source and extract, and then from the file menu export a packaged workbook. Then you upload the resulting TWBX.
Anyway, give the calc above a go first and see if it works!
Ta, Steve.