#Invalid Operation with MATCH formula


=MATCH([Program Unique ID]@row, [Program Unique ID]:[Program Unique ID], 0)

I am trying to use this formula to return which row # the first match is in so that I can automatically mark the first one and differentiate it from following duplicates, but my formula is returning #invalid operation.

Open to ideas on how to fix this or other ways to get what I am looking for.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!