I built a data set to automatically apply a task due date relative to a main project release date, but I’m now trying to apply that function to multiple projects that feed in from a lookup field. I was able to get it to stop ERROR messaging with ARRAYJOIN, but it’s only applying the DATEADD to the first date in the string, rather than applying it to both dates and outputting a string.
Alternatively, I’d love to output this into multiple records to be used like a to do list, but if I can at least get it to apply to multiple dates at once, I’ll be satisfied. Essentially, we have a ton of projects with similar timelines that fall on top of one another and I want to use this to manage the steps across multiple projects at once.
Here’s my formula right now. Adding a 2nd ARRAYJOIN neither fixed or broke my formula so I’m not sure where to go from here. Thanks!
ARRAYJOIN(DATETIME_FORMAT(DATEADD(ARRAYJOIN({Release Date (from Master)}, ", "), {Less Weeks}, ‘week’), ‘M/DD/YYYY’), ", ")
