Text, IF and dropdown function
 

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?

Text, IF and dropdown function
 

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)

"Pasty" wrote in message
...
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?

Text, IF and dropdown function
 

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" wrote:

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)

"Pasty" wrote in message
...
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?

Text, IF and dropdown function
 

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)

"Pasty" wrote in message
...
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" wrote:

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)

"Pasty" wrote in message
...
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?

Text, IF and dropdown function
 

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.

"Bob Phillips" wrote:

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)

"Pasty" wrote in message
...
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" wrote:

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)

"Pasty" wrote in message
...
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?