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. 

Capture for Community Question.JPG

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.