Multi-row Formula

[imivan]

I have been struggling with updating my existing column [Vendor], what I am trying to achieve is creating a formula to check if the value in the [Vendor] column is "Appendix A". If it is, it sets the value of the [Vendor] column for the next row (row+1) to "Appendix A":
IF [Vendor] = "Appendix A"
THEN [Vendor] = "Appendix A" and [Row+1:Vendor] = "Appendix A"
ELSE [Vendor]
ENDIF

However, the output changed "Appendix A" to 0 and the data afterward still remains the same.

[Raj]

Share a sample input file

[imivan]

The input data are as shown in the screenshot, there are quite a few of sensitive data that cannot be shared

[binuacs]

@imivan Your vendor column is double and there is no value called "AppendixA". Can you screen shot a sample input file with the value Appendix A?

[imivan]

@binuacs the image with the name Screenshot 2023-07-27 131405.png shows the data with RecordID 4515 has "Appendix A" in its vendor column, however, the "Appendix A" is changed to 0 as shown in another screenshot

[binuacs]

@imivan Something like this?

[imivan]

@binuacs I think so, let me try it out first, thanks anyway

[imivan]

@binuacs  all the row after 4515 should be changed to "Appendix A" , I copied the exact same formula to my case but it didn't work as intended, instead, only the next row changed, but you already helped a lot, I will try to figure the rest out of myself

[binuacs]

@imivan apply the below formula then

[imivan]

@binuacs thanks, I managed to figure out the same formula you gave me, thank you so much