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.

"Judy Rose" wrote:

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.
--
Judy Rose Cohen