I posted this a few days ago and got some good responses, but nothing that's
actually accomplishing what I had hoped (maybe it really just can't be done)

The specifics a
Creating an NPO reimbursement form where, in order for the form to be valid,
the employee needs to enter a project code into a column entitled '"Project"

The goal is to make it so that if this column is not filled in, an error
message will show up in the Grand Total or the person will be unable to
complete any more cells--sort of an enforced entry

Excel details:
Project column is column J
Grand Total cell is L22
Columns where expenses are entered are from B to I (Project is last column)
Rows where expenses are entered are from 8 to 21, with 22 being each
column's total
Not all rows/cells have to be filled in for the form to be valid but if a
row is used, it must (ideally) have a required Project code

I have tried:
1. An IF statement in the Grand Total cell (L22) but this leaves me with a
'true' or 'false' entry, not a number as it needs to be
2. A Validation where the employee has to select from a list of project
codes but an erro will only show up if they type an incorrect code, not if
they leave it blank

I'm new to this, so any other thoughts, ideas or help at all will b greatly
appreciated. Thank you in advance!

Hi:
Re #2: make sure your list of projects is picked from an accurate range,
i.e. not including an empty cell AND make sure "ignore blank" is selected.
Then the user cannot select a blank (i.e. leave it blank). You must protect
the cell from changing (choose Format/Cells/Protection and check Locked
(which is the usual default).

This doesnt prohibit selecting the wrong project. For this, you might add
to yr list of projects [Select Project].
Next, make your costs input conditional on the selection of the project
code. For the cell where cost entries are required, choose Data/Validation
and choose Custom in the Allow field. Now put in the Formula field
=$J1<"[Select project]" Copy this to all cells where costs needs to be
entered. This will create an error when no project code is selected (i.e.
where the project cell has the text [Select Project]), and a cost cannot be
entered. With conditional formatting you can make quick visual checks, e.g.
you can assign unique colours per project. Don't forget to protect the cells
and the sheets (otherwise the cell protections are not activated) to protect
the sheet from changing / deleting critical cell contents.
GL,
Henk


"smistretta" wrote:

I posted this a few days ago and got some good responses, but nothing that's
actually accomplishing what I had hoped (maybe it really just can't be done)

The specifics a
Creating an NPO reimbursement form where, in order for the form to be valid,
the employee needs to enter a project code into a column entitled '"Project"

The goal is to make it so that if this column is not filled in, an error
message will show up in the Grand Total or the person will be unable to
complete any more cells--sort of an enforced entry

Excel details:
Project column is column J
Grand Total cell is L22
Columns where expenses are entered are from B to I (Project is last column)
Rows where expenses are entered are from 8 to 21, with 22 being each
column's total
Not all rows/cells have to be filled in for the form to be valid but if a
row is used, it must (ideally) have a required Project code

I have tried:
1. An IF statement in the Grand Total cell (L22) but this leaves me with a
'true' or 'false' entry, not a number as it needs to be
2. A Validation where the employee has to select from a list of project
codes but an erro will only show up if they type an incorrect code, not if
they leave it blank

I'm new to this, so any other thoughts, ideas or help at all will b greatly
appreciated. Thank you in advance!