Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

Business Days Formula

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

1 Answer

1vote

ANerdyNotioneer01s Points1740

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

@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

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

Thanks @ANerdyNotioneer01s Notion confirmed the info you gave me.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect