Put this in the "1" column
=IF(A1="Breakshift",1,"")

Sherees wrote:

for eg if i enter in a column Breakshift, i want in another column digit one
automatically. what is the formula for this? Does the if function work only
for numbers or it works for alphabets too?