thanks Mark (Clay) that appears to have worked, I did have the table auto update setting turned off and was going through each column manually and it was working fine for other columns, but this one was throwing the issue
do I need to have the table auto update setting turned on even if I manually run each column?