Auto entry of data based on entry of text in another column or fie

J

Judy Rose

I have a spreadsheet for each month of the year to track my reappointment
evaluations, each month I get a list of who is supposed to be reviewed next
month and I type it into my spreadsheet for the given month, my question is I
have a sort indicator that should read "1" in column A as soon as I enter a
value into column B for the given row. Is there any way to get the system to
do this for me automatically or do I have to continue to manually enter the
"1" on each row I use.

Thank you for any help.
 
S

SSG QuarterMaster

Try this formula:

in column A1 enter: =IF(B1="","","1") if you need the "1" to be a number
then disregard the quotes aronud the 1. and replace the cell references with
the appropriate references.
 
J

Judy Rose

Thank you, I figured it was an If statement, but couldn't figure out the
exact way to phrase the B1 information. You have been very helpful.
 
Top