Help between Notion users

It's free & easy

Receive points, vote and give the solution

# Question

1vote

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

1vote

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)

0vote

### Dennismel12 commented Jan 16, 2023

@ANerdyNotioneer01s thank you for responding. I can't seem to find anything online about this hard limit. I would like to share this with my team, but with something to back it up. Do you have any sources, or is this just a known thing with Notion?

1vote

### ANerdyNotioneer01s commented Jan 17, 2023

I don't think there is documentation of it (or at least not what I can find at the moment), just what Notion has told us in the past and through previous discussions with others.

1vote

### Dennismel12 commented Jan 23, 2023

Thanks @ANerdyNotioneer01s Notion confirmed the info you gave me.

...