Multi-Row Formula Tool

[Jgrillo19]

I need help stopping the process from looping once I hit the last row. The last row is showing as blank, but it should be populated with what was previously there. What condition do I need to enter into my code so it does not look for a row below that doesn't exist? See my code in the image attached. 

[gawa]

hi @Jgrillo19  To know hitting the last row in the IF statements, first change option as below

 

Then ,put the below statements at first part of IF statements.(The rest part can maintain as it is)

IF IsNull([Row+1:Engagement Proft Center Code]) THEN null()
ELSEIF 

 By doing so, it will return 'NULL' at last row.