Pull the Most Recent Submission

SarahMcIntosh62

Hello!

I have not written formulas in quite some time, and need some help.

I want to check the "Most Recent" box, if it is the most recent submission for that workstream.

Nick Korna

Hi @SarahMcIntosh62,

You can do this with a IF, MAX, COLLECT combination:

=IF(MAX(COLLECT(Created:Created, Workstream:Workstream, Workstream@row)) = Created@row, 1, 0)

This would tick the box for the most recently created row in a given Workstream.

Hope this helps, but if I've misunderstood something or you've any problems/questions then just post!

Nick Korna

Hi @SarahMcIntosh62,

You can do this with a IF, MAX, COLLECT combination:

=IF(MAX(COLLECT(Created:Created, Workstream:Workstream, Workstream@row)) = Created@row, 1, 0)

This would tick the box for the most recently created row in a given Workstream.

Hope this helps, but if I've misunderstood something or you've any problems/questions then just post!