Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Holiday Rollup Field Not Working in WORKDAY Formula

Topic Labels: Formulas
822 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauren_Noack
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a list of Holiday dates in a rollup field linked to another table. I tried to add that rollup list of dates to my WORKDAY Formula, but it’s producing an error. If I copy/paste the string of dates between ‘single brackets’ the formula works perfectly but I can’t surround the Holiday field in single brackets. Here is what I currently have:

IF({OE Date},DATETIME_FORMAT(IF({Deposit Hard Date},
{Deposit Hard Date},WORKDAY(DATEADD({OE Date},
{Deposit Due (Days)}-1,'days'),1,Holidays)),'MM/DD/YY'))
0 Replies 0