How to select the most recent arrayunique(value)

[Bruce_Horwitz]

Greetings - I’m using arrayunique(value) for rollups to scan shopify orders and copy over information to my customer, including phone number and delivery day. Problem is when I receive 2 or more different values, I need the most recent one only. How would I compare date values and return the most recent non-blank value?

[Kamille_Parks]

Try using MAX(values)

[Bruce_Horwitz]

I did - that returns zeros. I also tried Max(arrayunqiue(values)) and got zeros as well. So - I need to check the Created Date of each unique record and only return the text fields from the most recent created date. I just don’t know how to do that yet.

[Kamille_Parks]

You’ll need a similar process as described here:

Show most recent status update per Step Base design

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: 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 m…