| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel dropdown with text and value | Excel Worksheet Functions | |||
| Do dropdown lists have an autocomplete function? | Excel Discussion (Misc queries) | |||
| no show all function in dropdown list in Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 97 dropdown function box | Excel Discussion (Misc queries) | |||
| Text Size in Dropdown | Excel Discussion (Misc queries) | |||
Linear Mode
