Board B has a list of Posts, which includes a Date field as well as a field that’s connected to the Authors board. Some Authors appear in multiple Posts records. (Screenshot: Imgur: The magic of the Internet )
I would like to add a “Most Recent Post Date” to the Author board that, well, shows the date of the most recent Post in the Post board that’s attributed to a given Author.
So, I need two things:
A way to update the entire Authors board with the current “Most Recent Post Date” values.
An automation to update the Authors board any time a new Post is added to the Post board.
You can do this without any manual updates or custom automation.
On the Authors board:
Add a Mirror column that mirrors the Post Date from the Posts board, using your existing Connect Boards link.
Then add a Formula column and use: MAX({Mirrored Post Date})
This will automatically show each author’s most recent post date for all existing posts and any new ones going forward.
If you’d like hands-on help or want us to walk through this live, you can book a 1:1 paid 60-minute strategy session with our team here: Calendly
I see in your images that you’re already using a connected column to connect the posts board to the authors board. On the Authors board, simply add a ‘Mirror’ column and then choose the ‘Post Date’ column from your posts board to pull to the authors board. When you mirror a date column you get this option where you can choose to show the ‘latest’ date which would be the most recent.
Hi @daniellerch
Yes, this can be achieved using Make automations.
With ‘Make’ you can check the Posts board, find all posts connected to each Author, and identify the most recent post date. It can then automatically update the “Most Recent Post Date” column on the Authors board with the correct value.
You can set it up in two parts:
First, run it once to update all existing Authors with their latest post date.
Then, keep it running so whenever a new Post is added or updated, Make automatically updates the corresponding Author’s “Most Recent Post Date.”
This keeps the Author board always up to date without any manual work.
Thanks Desiree. I tried that, but even thought I’d set it to “Latest”, it grabbed the earliest date from the Author in the first listed Group. What I want is the latest date from the Author from in the whole board.
Thanks. I tried that but it only returned the value “0”; and when I asked the AI to troubleshoot it told me this: “Sorry, monday.com’s Formula column can’t automatically show the latest date from multiple linked values in a mirror column like “Latest Post Date.” It only works with single values or calculations within the same item.“
If the Mirror option is pulling the wrong value, try mirroring the Post Date as a list of all linked dates not the single “Latest display, then use a Formula with MAX on that mirror column so it evaluates every post date for the author. Also make sure the Posts Date is a true Date column not text and that you do not have blank dates, since those often cause the result you saw.
Hi Daniel! What you’re trying to do is a classic example of workflow automation challenges. Setting up a field to always reflect the most recent linked item is all about ensuring your automation logic correctly references the latest record. For anyone looking to understand broader automation concepts that can inspire similar solutions, this article on AI automation and cybersecurity for leads provides some interesting insights into how automated systems track and update data efficiently.
