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

Hi everyone!

I’m running into a limitation in Notion and could use some advice or confirmation if this is possible. Here’s my setup:

Two Databases:

  1. Calendar.
    Properties: Date (when the task was completed), Relation to the Chores database.

  2. Chores Database:
    Properties: A relation to the Calendar database, A rollup called Last Done, which fetches the latest date a chore was completed from the Calendar database.

Problem:
I want the Chores database to show the name of the person who last completed a task, i.e., the Name value from the Calendar entry corresponding to the Last Done date.

1 Answer

1vote

thomas_yang Points3300

In your case you'll need to use the formula map() and filter() to achieve this. It's fairly complicated for newer user but I've recorded a video as well to try to explain, if not just duplicate the code :)

Here's an example and template that you can duplicate:

https://www.digital-cookie.com/Using-Rollup-to-Track-the-Last-Completed-Date-by-a-Person-154f60eceaf680e0b095fa843648a3f0?pvs=4

2votes

mdgalati commented

Wow, what an extensive answer! Thank you very much, I managed to do it!

2votes

thomas_yang commented

you're welcome!

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