Hey all,
Mirror columns have the ability to show min/max…
Is there a way for a mirror column to pull in the most recently created value?
Or has anyone figured out a formula to do it?
Hey @DannyP!
Would you be happy to elaborate a little further on what you mean by recently created value? The mostly recently created value in the connected board? Can I ask if the last updated column would fulfil this function?
Hey @BiancaT
Thanks for getting back to me!
TABLE B - Daily Cashflow
Date | Amount Overdue
TABLE A - Summary
Department | Linked Date (multiple selected) | Linked Amount
So for example, in TABLE A, I am trying to get the ‘Linked Amount’ to show the last created (the newest date), which is the current amount overdue.
Does that make sense?
Thanks for your reply @DannyP!
Let me know if I’ve understand correctly - essentially instead of the linked amount displaying as a total of the connected items/dates, you’d only like it to display the most recent date’s amount?
Hi @BiancaT,
No slightly different.
Say for example I have 2 tables.
EXAMPLE 1
Every day I input a value in this table.
EXAMPLE 2
This tables links to EXAMPLE 1 and connects to each new entry (via the link column).
In EXAMPLE 2 it has a mirror column that brings in all the numbers from EXAMPLE 1.
I only want the mirror column to display the number that is attached to the most recent linked date. In this example the mirror column should show 4%.
EXAMPLE 1 - Table
EXAMPLE 2 - Table
Thank you for these screenshots and further insight! I am afraid that as long as you have multiple items connected, the value in the mirror column will always be a product of all items. If you only want a specific (connected) item’s value to display, only that item can then be connected - does this make sense? I apologise for the setback here - your feedback has certainly been noted!
Thanks Bianca, appreciate the help
1 Like
+1 for this as a feature suggestion… would be massively useful.