Looking for help to modify an Index formula to combine previous entry's from forms

griffong

Hello,

I have a dashboard that displays form submission data using this formula:=INDEX([Submission Date]:[Open Space Link], 1, 3)

Current Behavior:

• The formula shows the most recent form submission
• When users submit partial updates (filling only 1-2 fields), only those new values appear on the dashboard
• Previous valid data in other columns gets lost

Desired Behavior:

• Display the most recent submission data
• If recent submissions have empty fields, retain/show the last known valid data from previous submissions for those fields

Is there a formula or function that can maintain historical values for empty fields while still showing the latest updates?

Paul Newcome

You can use a COLLECT function to filter out blanks.

=INDEX(COLLECT([Open Space Link]:[Open Space Link]:[Open Space Link]:[Open Space Link], @cell <> ""), 1)