Update:
I managed to address the corner case where the template column output would not be correct for the first row entry.
I simply used an “If then else column” to basically insure that the desired Template column output would be the expected value.
Solved my own issue.