Trying to anchor formula to specific row

Hi, I have entered this and it works:

=IF(FIND([SOP Required Group]1, [SOP Required Group]@row) > 0, "Y", "N")

but if I want to anchor to Row 1, I get an #unparseable error:

=IF(FIND(SOP Required Group1, [SOP Required Group]@row) > 0, "Y", "N")

What am I missing?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!