I am looking to show the most recent status update for each step.
My table includes:
Steps (Individual steps within the objectives)
Status Reports (form for the team members to submit updates for each steps)
A few questions:
- Should I create some sort of a filter/automation within the Status Report table to show the most recent status per step?
- Do I need another table (something like “Most Recent Updates”) that pulls from Status reports and somehow only shows the most recent step?
- Can I show the most recent updates right in the Steps table? (This is what I’d prefer, but i’m not sure what fields I would need to add / filter / sort by to make that happen)