Help

Holiday Rollup Field Not Working in WORKDAY Formula

Topic Labels: Formulas
349 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