The column formula syntax isn't quite right

MeganE
MeganE
edited 05/31/24 in Formulas and Functions

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,

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!