Notion Answers

Get help from other 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

How to count out of date tasks from another page table?

I have a table on one page with a full tracker of tasks in table form and when they are due. When they are overdue they turn red. I would like a table on the dashboard/main page that counts how many tasks are out of date and are showing red. I'm not sure if this is even possible and can't find an option on the roll up.

Is there any way of doing this? Any help would be greatly appreciated! :)

0vote

polle commented

Do you have a page to share so I can see how you have things setup?

1 Answer

1vote

LamboNr5 Points240

Create a column with formula: if(prop("Due Date") > now(), format(prop("Name")), "")

Now go on your main page and create a linked database to your task tracker. Then add a filter: Just show Formular column that is not empty. At last you kick out the property due date. Now you see the names of overdue tastks and you can say that you want to count them at the bottom of the database.

Hope that helps :)

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

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