Question

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())))))))

Answer 1

Notion has set a hard limit on this for 7 columns. This is to help prevent feedback loop errors. (Trust me, we all have gone through this at some point or another)