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.
