Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 13, 2023 05:29 PM
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
