Sep 18, 2020 07:47 AM
I am looking to show the most recent status update for each step.
My table includes:
Objectives
Steps (Individual steps within the objectives)
Team Members
Status Reports (form for the team members to submit updates for each steps)
A few questions:
Sep 18, 2020 08:02 AM
Do the following:
Steps
to show the MAX(values)
of the {Date}
field in the Status Reports
table.Status Reports
that points at that^ field, using a aggregation formula like: IF({Date} = MAX(values), "true", "false")
. All the ones that compute true should be the latest status update for a particular step.Steps
to only pull the {Step Name}
field (or whatever) if that^ field = true.Sep 18, 2020 08:57 AM
I must be doing something wrong because my most recent update is still false:
Sep 18, 2020 09:11 AM
Try making the rollup just MAX(values)
, and use a formula field that’s IF({Date} = {Rollup field} "true", "false")
?
Sep 18, 2020 10:26 AM
Got it!
Thank you very much!