Show completed tasks on daily log

Hello, newbie here. I’m sure this is a really basic question, but I can’t wrap my head around it.

I have a table of tasks and a separate daily log table where I track everything that happened that day. I want to be able to see all of the completed tasks for each day as a table in the expanded view of the daily log entries.

I created a linked relation column so the table shows up inside the expanded row of the daily log, but I’m not sure how to set the formula to populate it with the corresponding completed tasks for that date. Do I somehow filter it for matching dates?

I created a dummy document for this: https://coda.io/d/_dbmEpKPDzv1/Dummy-Doc-for-Displaying-Completed-Tasks-on-Daily-Log_suomEuZR

Any help is appreciated. Thank you!

1 Like

Hi Jaelin,

Welcome to the community!

I took the liberty to duplicate your column and fix the issue there.

Yes, that was the way.

Here’s the formula Tasks.Filter([Date Completed]=thisRow.Date), which in plain english means: Give me all the items from tasks where Date completed is equal to this row’s date.

Hope this helps,

Pablo

1 Like

This is exactly what I was missing. Thank you SO much!

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.