Greetings, you're input is greatly appreciated:

Effort: Have column formula populate if there is data in a row AS entered
Deter: Copying formula in enitre column which results maxxing out excel rows
and poor printing

Current Formula:
=IF(Disc_Complete="","",IF(A2=1,"RB",IF(A2=2,"JM", IF(A2=0,""))))

Considerations: Column C will always have data and was thinking to build
something based off of if C was not blank, to have the formula auto populate
into B.

Currently we have to drag/drop as entered which other unfamiliar employees
using worksheet do not manage well. :-)

Suggestions?