Question

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.

Answer 1

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