Text, IF and dropdown function

[Guest]

I need to set it up that if they put in a certain date for an "actual end
date" for an action and it is equal to the "Planned Action End Date for open
actions" they will then get a drop down list for the question will this
"action become a control" which they can only answer yes or no to based on
the above being satisfied.

From this if the answer is yes the text in the "action" cell will be added
to the controls cell, put in a cell for "closed actions" and also the "actual
end date" will feed into a "End date for closed actions" cell.

If the answer is no the text in the "action" cell will only be added to the
"closed actions" cell and "End date for closed actions" cell.

Is this possible?

 

[Bob Phillips]

You could put yes/no in say M1:m2, and add this to the data validation with
an allow type of List

=IF(actualenddate=plannedenddate,M1:M2,"")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

Thanks for your help and its putting me in the right direction. The only
thing it doesn't do is allow for the fact that it needs to fire the date off
to a different cell as well, also I have it set up so I can only have the
drop down box if both cells are the same using data validation with this
=IF($I$33=$J$33,$L$26:$L$27,) which work on my working out sheet but when I
tried to apply it to the actual sheet it came back with the response "THE
LIST SOURCE MUST BE A DELIMITED LIST, OR A REFERENCE TO SINGLE ROW OR COLUMN"
would there be any particular reason for this?

 

[Bob Phillips]

That sounds as if you used the formula

=IF($I$33=$J$33,$L$26:$L$27)

rather than

=IF($I$33=$J$33,$L$26:$L$27,)

or

=IF($I$33=$J$33,$L$26:$L$27,"")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

That's not it unfortunately, might be the formatting or something else I'll
have a play around and see what happens. Thanks for your help.