Help

Formula Field as a Look-up Field

Topic Labels: Formulas
357 0
cancel
Showing results for 
Search instead for 
Did you mean: 
elisess
4 - Data Explorer
4 - Data Explorer

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')
 
))))))))))))))))))))
 
0 Replies 0