Hey, very useful thank you! Only problem I'm having so far is a formula parse error on the Origin tab for the DLC Warden-Commander dropdowns. The two formulas are: =IF(NOT(OR(K28=[1]Dropdownliste!B3,K28=[1]Dropdownliste!B4,K28=[1]Dropdownliste!B5)),"",IFERROR(VLOOKUP(H29,[1]Dropdownliste!C10:D12,2,FALSE),"")) and =IF(NOT(OR(K33=[1]Dropdownliste!B3,K33=[1]Dropdownliste!B4,K33=[1]Dropdownliste!B5)),"",IFERROR(VLOOKUP(H34,[1]Dropdownliste!C10:D12,2,FALSE),"")) I think these are supposed to pull the Gray Warden information from B2-5 and E2-5, but there seems to be something wrong with it. I'm using google sheets, if that makes any difference.
It should not be a problem, wich programm is opening the files. I have found out, that the fourmular is geting the data from a diffrent verion of this files (from the Optinal files). In that case the [1] can be deletet and it should work fine.
Somehow, this copy paste issue from the german verision has bypassed me. Thanks for the report. I will take it in my developer files and once more issue has been reportet (or DA 4 is released) I will update all the files.
not sure what you mean by "instruction" since all the things are labelled in the "Legend" tab. There is a list to select from in all yellow cells. all the orange ones are free fields. all the other stuff is automatically generated.
I added a separate page for the links because I noticed that the links cannot be opened. Because the cells are all protected and therefore cannot use a link. That is the reason why. So that it is clear to everyone. Thanks for your understanding. ——— Ich habe einen eigenen Seite für die Links eingefügt, weil ich gemerkt habe, dass man die Links nicht öffnen kann. Weil die Zellen alle geschützt sind, und dadurch keinen Link benutzten kann. Das ist der Grund dafür. Damit das für alle klar ist. Danke für euer Verständnis.
First of all, thank you very much for this amazing work. Just one thing, do you mind translating the label of the lists (are written in the green cells) in the Dropdownliste? (I've downladed the English version)
Give Feedback
7 comments
=IF(NOT(OR(K28=[1]Dropdownliste!B3,K28=[1]Dropdownliste!B4,K28=[1]Dropdownliste!B5)),"",IFERROR(VLOOKUP(H29,[1]Dropdownliste!C10:D12,2,FALSE),""))
and=IF(NOT(OR(K33=[1]Dropdownliste!B3,K33=[1]Dropdownliste!B4,K33=[1]Dropdownliste!B5)),"",IFERROR(VLOOKUP(H34,[1]Dropdownliste!C10:D12,2,FALSE),""))
I think these are supposed to pull the Gray Warden information from B2-5 and E2-5, but there seems to be something wrong with it. I'm using google sheets, if that makes any difference.It should not be a problem, wich programm is opening the files.
I have found out, that the fourmular is geting the data from a diffrent verion of this files (from the Optinal files). In that case the [1] can be deletet and it should work fine.
Somehow, this copy paste issue from the german verision has bypassed me. Thanks for the report.
I will take it in my developer files and once more issue has been reportet (or DA 4 is released) I will update all the files.
There is a list to select from in all yellow cells. all the orange ones are free fields.
all the other stuff is automatically generated.
Thanks for your understanding.
———
Ich habe einen eigenen Seite für die Links eingefügt, weil ich gemerkt habe, dass man die Links nicht öffnen kann. Weil die Zellen alle geschützt sind, und dadurch keinen Link benutzten kann. Das ist der Grund dafür. Damit das für alle klar ist.
Danke für euer Verständnis.
Just one thing, do you mind translating the label of the lists (are written in the green cells) in the Dropdownliste? (I've downladed the English version)
You mean the "Dropdownlisten"-Tab? My plan was, that you guys don't see this tab. But I will translate it as well.
Thx