I made a formula to get all the holidays for the current year automatically and I can’t use that value directly with WORKDAY_DIFF in another formula. I have to copy and paste.
If anyone has the answer I would love to have it, thanks a lot !
Well… It actually work !
Thank you I didn’t expected it to be an array since there is single quote on the field binded in the lookup, good to know !
Thanks again, have a great day :slightly_smiling_face:
Hello Justin, thank you veryy much ! :grinning_face_with_smiling_eyes:
I use two formula, one to get the holidays I want to exclude and another to get them into string, then I use a lookup on another table and I try to get the data from there.