Cannot convert to column formula


I've been banging my head against this issue and have not found a solution. I'm trying to convert a working formula into a column formula but keep getting a "not quite right" error. I thought other parts of the formula were incorrect so I removed them to see if that was the case but it's not.

I know having an absolute cell reference will prevent me from converting it into a column formula but I don't think I have any.

=SUMIFS([LIV603 - Information Technology]@row:[LIV241 - The Messina Group TX (1)]@row, [LIV603 - Information Technology]77:[LIV241 - The Messina Group TX (1)]77, [Column127]@row)

Any help would be greatly appreciated.

Thank you,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!