Allow single cell references to be converting to column formulas

Dani_torrone

Currently when you want to reference a single cell in another row you cannot convert the cell formula to a column formula without getting a syntax error even though the formula works fine as a cell formula.

I need this functionality as I am trying to figure out a work around to do round robin auto assignments for new items based off of who was assigned to the last item.

In my screenshot below, I have added a helper column called "previous onboarder" which I want to reference the previous row's "Onboarder" value so I can setup an automation to auto-assign an Onboarder to the next new item based on the "previous onboarder" value. My automation would say something like, When Request Number is changed and previous onboarder is Matthew Hayes assign Onboarder to Danielle Torrone. While single cell references are unable to be converting to column formulas I cannot think of another way to achieve the round robin assignment.