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

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

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

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

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

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


"SSG QuarterMaster" wrote:

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