Dual parameter formula to capture last entered date versus last date of column?

@Dan Palenchar returned an error.

@Genevieve P What I am wanting the formula to do is to pull the most recently updated date as the [Last Activity Date] column is updated or changed. Currently it works well if the date never needs to be adjusted to a date prior to what was retrieved by the current formula.

The bottom row example above shows what is happening when a [Last Activity Date] is changed to a date prior to the last entry on the end users sheet. Current formula in the [Intitial Presentation] column is:

=MAX(COLLECT({ROLL UP TEST Range 1}, {ROLL UP TEST Range 2}, [Account No.]@row, {COPY COPY ROLL UP TEST Range 1}, KAE@row))

It is referencing this sheet that is updated via a workflow to add new rows every time there is a new row added or changed on the end users sheet :

The column formula for the referenced sheet [Initial Presentation] column is (same for other columns):

=IF(AND([Last Activity Type]@row = "Survey", ISDATE([Last Activity Date]@row)), [Last Activity Date]@row, 0

Meaning if my end user enters a date of 11/12/2020 with an activity type of Initial Presentation, that date is pushed to the reference sheet as a new row. Works great if you never have to change a date back to a prior date than what was previously entered, hence my issue. Need it to pull the most recent date entered on the end user sheet so that if they make a mistake they can go back and change the date and it reflects properly on their sheet in the formula based 'static' columns (columns with conditional formatting in first image). Make sense?

@Genevieve P I may be screwing this up. Is the {Created Date} referencing the roll up sheet that new rows are pushed to when the end user changes dates or supposed to reference the end users sheet?

=MAX(COLLECT({COPY COPY ROLL UP TEST Range 1}, {COPY COPY ROLL UP TEST Range 2}, [Account No.]@row, {COPY COPYROLL UP TEST Range 1}, KAE@row, {COPY COPY ROLL UP TEST Range 3}, MAX(COLLECT({COPY COPY ROLL UP TEST Range 3}, {COPY COPY ROLL UP TEST Range 2}, [Account No.]@row, {COPY COPY ROLL UP TEST Range 1}, KAE@row))))

Using the roll up sheet created column ({COPY COPY ROLL UP TEST Range 3}) I am getting a blank cell even with a date being entered the first time.

I am still having trouble. May be mixing up the references on my end I see "{ }" as a reference to a different sheet, and "[ ]" to the current sheet. Happy to share my sheets as neither have anything confidential if that would help.

@Leibel S I have no idea what I am screwing up. So sorry for the back and forth!

My end user sheet where they enter a [Last Activity Date] and [Last Activity Type] and adds a new row to a separate sheet through workflow is still pulling the first entered date.

Formula for the cell in pink is: (notice cell in red should have changed it)

=INDEX({3rd COPY ROLL-UP Range 1}, MAX(COLLECT({3rd COPY ROLL-UP Range 2}, {3rd COPY ROLL-UP Range 3}, [Account No.]@row, {3rd COPY ROLL-UP Range 4}, "Initial Presentation")))

Here are the ranges being referenced in the formula on the collection sheet "3rd COPY ROLL-UP":

Date I need in the pink cell of the end users sheet is highlighted in purple on the collection sheet.

The formula in the far right column of the collection sheet is: =IF(AND([Last Activity Type]@row = "Initial Presentation", ISDATE([Last Activity Date]@row)), [Last Activity Date]@row, 0