[ownedbycats]

I use a custom stored template, readstatus(), which checks several other columns and then produces a read status based on it.

program:

	if 'dnf' inlist $#admintags
	then 'didnotfinish'

	elif ($$#percentread >=#1 && $$#percentread <=#99) || ($#readinglist == 'Reference')
	then 'currentlyreading' 

	elif $#readinglist=='To Be Read' && $$#percentread ==#0
	then 'toberead' 

	elif $$#percentread >=#100
	then 'read' 

	elif $$#percentread == 'None'
	then 'undefined' 

	elif $$#percentread >=#0
	then 'unread' 

	fi

I use it in various other templates, including a composite column that displays a more readable version (e.g. 'Currently Reading' instead of currentlyreading).

Most users could probably get away with just a composite column.