I need to write following Excel formulas in MS Project. Could you please help?

[Dezom]

Hello Everyone,

I need help from you to write formulas in MS project. I had a file in Excel. But I need to use MS Project because of management decision. MS Project formula language is different and I do not have any experience about it before. I will be really glad if you can help me about it. In the table I have made the columns yellow which has following formulas.

Those three formula I need to write;

Formula1:

IF(OR(E2="Adjustment";E2="Secondary Work";E2="Technical Secondary Work";E2="Production";E2="Engineering Control Work");WORKDAY.INTL(H2;2;1);IF(OR(E2="Quality Control Work";E2="Assemble");WORKDAY.INTL(H2;1;1);IF(AND(E2="Primary Assemble";M2>G2;M2<N2);N2;EĞER(VE(E2="Primary Assemble";G2<MIN(M2;N2));MIN(M2;N2);IF(AND(E2="Primary Assemble";G2>MAK(M2;N2));WORKDAY.INTL(H2;2;1);"cant be calculated")))))

Formula 2:
IF(AND(H2>=DATE(2020;1;1);H2<=DATE(2020;1;4));"W1";IF(AND(H2>=TARİH(2020;1;6);H2<=DATE(2020;1;11));"W2";"continue")

Formula 3:
IF(ISNUMBER(SEARCH("Adjust";D3));"Adjustment";IF(ISNUMER(SEARCH(" TN ";D3));"Technical Secondary Work";IF(ISNUMBER(SEARCH("Production";D3));"Production")))

Paylaşım Prototip.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Employee	Week	Task	Task Description	Task Type	Duration	Date for assigning the task	Planned Task Termin	Statu of Task	Real Finish Date	Time Period	Final Termin	Calendar Termin based on Time Period	Termin based on Vehicles
2	John	will continue	1224	Primary Assemble F40-9999 Illustration Edition	Primary Assemble	14	23.7.20	8.8.20	OK	6.8.20	30 TP	28.8.20	1.9.20	28.8.20
3	Jonathan	will continue	1564	Primary Assemble BVN003 F41-9888 Electrical Cabling	Secondary Work	22	23.7.20	29.7.20	OK	7.8.20	28 TP	31.7.20	17.8.20	17.7.20
4	Harry	will continue	1767	Primary Assemble Quality Control Work F39-5555 Lighting Edition	Quality Control Work	5	23.7.20	24.7.20	OK	25.7.20	26 TP	27.7.20	2.7.20	16.7.20
5	Hans	will continue	2334	Primary Assemble Adjustment F41-9888 Electrical Cabling	Adjustment	9	23.7.20	21.8.20	Working		30 TP	25.8.20	1.9.20	28.8.20
6	Alice	will continue	7886	Primary Assemble Production F88-3579 Heating work	Production	4	23.7.20	27.7.20	OK	28.7.20	21 TP	29.7.20	8.6.20
7	Marry	will continue	5331	Primary Assemble 30C-8456 creating a new group	Primary Assemble	20	23.7.20	14.9.20	Waiting		33 TP	18.9.20	16.9.20	18.9.20
8	Karhan	will continue	1005	Primary Assemble 30C-6578 creating a new group	Primary Assemble	32	23.7.20	14.9.20	Waiting		33 TP	18.9.20	16.9.20	18.9.20
9	Sitovic	will continue	9564	Primary Assemble TN 30C-1234 Controlling a new group	Technical Secondary Work	8	23.7.20	14.9.20	Waiting		33 TP	16.9.20	16.9.20	18.9.20
10	Boris	will continue	Checklist	F40-9999 Checklist Primary Assemble	Checklist	20	20.8.20	29.8.20	Working			cant be calculated
11
12
13
14
15
16	Formulas
17	Final Termin (L2)
18	Week (B2)
19	Task Type (E2)
Prototype

 

[sandy666]

Project functions for custom fields in Project desktop

These functions are used within formulas in order to calculate the values for custom fields.

support.microsoft.com

.
or maybe import Excel to Project and map fields then, if something will change in Excel, update project