Hello,
I’m having an issue with a formula that I am using. It works perfectly fine for 7 columns, then just stops working for the 8th and the 9th column.
The formula adds a specified amount of business days in each column, and references the previous column. The first column that starts this thread is a dates column. I’ve included a short video to show the problem.
I’d really appreciate any help with this.
Loom video (under 2 mins):
https://www.loom.com/share/87b4caa445314395b3fb37eaf1d6be07
Formula:
if(day(prop("Research start")) == 0, dateAdd(prop("Research start"), 5, "days"), if(day(prop("Research start")) == 1, dateAdd(prop("Research start"), 7, "days"), if(day(prop("Research start")) == 2, dateAdd(prop("Research start"), 7, "days"), if(day(prop("Research start")) == 3, dateAdd(prop("Research start"), 7, "days"), if(day(prop("Research start")) == 4, dateAdd(prop("Research start"), 7, "days"), if(day(prop("Research start")) == 5, dateAdd(prop("Research start"), 7, "days"), if(day(prop("Research start")) == 6, dateAdd(prop("Research start"), 6, "days"), now())))))))