The column formula syntax isn't quite right

MeganE

Hello,

I am getting the error that the column formula syntax isn't working. I have used the @row function and it works in each cell, it just can't be converted to a column formula. Any help is appreciated.

This is for the "P/D PMI PMLast" column.

=IF($[P/D PMI PM]@row = "", "", RIGHT($[P/D PMI PM]@row, LEN($[P/D PMI PM]@row) - (FIND(" ", $[P/D PMI PM]@row, 1))))

Edit: I also tried removing the "$" and it still does not work.

Thanks,

Kelly Moore

Hey @MeganE

The dollar-sign is your culprit. That is also absolute reference, which column formulas cannot have. Lose the dollar signs.

Kelly

Kelly Moore

Hey @MeganE

The dollar-sign is your culprit. That is also absolute reference, which column formulas cannot have. Lose the dollar signs.

Kelly