Dupplications / look-up

[elisess]

Hi there, 

I have a repetitive formula field that I need to turn into a lookup / roll-up field in another table.

Here is the formula field for reference. What are the steps I need to take to allow for this formula field to be a lookup field on another table?

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 1'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-25,'Days'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 2'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-18,'Days'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 3'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-11,'Days'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=1, {Email Week}='Week 4'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-4,'Days'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=2, {Email Week}='Week 1'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-4,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=2, {Email Week}='Week 2'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-3,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=2, {Email Week}='Week 3'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-2,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=2, {Email Week}='Week 4'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-1,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=3, {Email Week}='Week 1'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-4,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=3, {Email Week}='Week 2'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-3,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=3, {Email Week}='Week 3'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-2,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=3, {Email Week}='Week 4'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-1,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=4, {Email Week}='Week 1'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-4,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=4, {Email Week}='Week 2'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-3,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=4, {Email Week}='Week 3'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-2,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=4, {Email Week}='Week 4'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-1,'Weeks'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=5, {Email Week}='Week 1'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-29,'Days'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=5, {Email Week}='Week 2'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-22,'Days'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=5, {Email Week}='Week 3'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-15,'Days'),

IF(

AND(

WEEKDAY({Go Live Date / Event Start Date (from Program Name)})=5, {Email Week}='Week 4'),DATEADD({Go Live Date / Event Start Date (from Program Name)},-9,'Days')

 

))))))))))))))))))))