=IF(OR(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",[DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)"), "FILLING"), IF(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)", [DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",OR([Priority]10 = "HIGH","MEDIUM")), "QUICK WIN"),IF(AND(OR([UI UX LEVEL OF EFFORT]10="X-SMALL (less than 5 hours)","SMALL (less than 20 hours)","MEDIUM (40 to 80 hours)"),OR([DEVELOPMENT LEVEL OF EFFORT]10="X-SMALL (less than 5 hours)","SMALL (less than 20 hours)","MEDIUM (40 to 80 hours)"),[Priority]10="HIGH"),"QUICK WIN"),IF(AND(OR([UI UX LEVEL OF EFFORT]10="LARGER (80 to 120 hours)","X-LARGE (more than 120 hours)"),OR([DEVELOPMENT LEVEL OF EFFORT]10="LARGER (80 to 120 hours)","X-LARGE (more than 120 hours)"),OR([Priority]10="HIGH","MEDIUM")),"MAJOR PROJECT"),IF(AND(OR([UI UX LEVEL OF EFFORT]10="LARGER (80 to 120 hours)","X-LARGE (more than 120 hours)"),OR([DEVELOPMENT LEVEL OF EFFORT]10="LARGER (80 to 120 hours)","X-LARGE (more than 120 hours)"),[Priority]10="LOW"),"THANKLESS EFFORT")))
if UX UI level of Effort is X-SMALL and Development LEVEL OF Effort is X-SMALL then regardless what total value score ( priority) is just mark ACTION PRIORITY as FILLIN
UX UI level of Effort is X-SMALL and Development LEVEL OF Effort is X-SMALL and total value score ( priority) is HIGH or MEDUIM then mark ACTION PRIORITY as QUICK WIN
UX UI level of Effort is X-SMALL OR SMALL OR MEDIUM and Development LEVEL OF Effort is X-SMALL OR SMALL OR MEDIUM and total value score (priority)is HIGH then mark ACTION PRIORITY as QUICK WIN
UX UI level of Effort is LARGE or X-LARGE and Development level of Effort is LARGE or X-LARGE and total value score ( priority) is HIGH or MEDUIM then mark ACTION PRIORITY as MAJOR PROJECT
UX UI level of Effort is LARGE or X-LARGE and Development level of Effort is LARGE or X-LARGE and total value score ( priority) is low then mark ACTION PRIORITY as thankless effort