Using Data Validation & If Formula

[Literae]

Bonjour all,

First time poster! Been using this site to help me make some spreadsheets for work. All have been a great help and have been learning new things and tricks every day.

Anywho! Thats enough of me....I have a problem I am trying to get around and wondering if you all could help?

I currently have a google spreadsheet (please be kind :D, hopefully the formula is the same as excel) that has a list of outstanding orders I chase daily. I currently have 2 additional columns at the end of my sheet that has a network days formula running (Col I). In the final column I have a "Status" (Col J) section which I use a data validation droplist. I currently have a formula of:

=IF(I14<3 "NEW ORDER"," ")

New Order is one of my drop downs which I would manually select if the order is 1 or 2 days old. Anything above 3 I use a selection of drop downs depending on the order / comments that are made against them.

However, when I have this formula is in place (it works), but the drop down no longer works. Is there any way around this?

TLDR: I would like to use my new formula to automatically fill Column J, but still be able to use the drop down list in Column J.

Many thanks in advance!

Dan

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/gener...1055253-using-data-validation-if-formula.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.