Formula help

Can someone help me with a formula that would produce the hand keyed results in "Unique ID"?

I want to produce a unique ID in sequential order for each record that "Job #" and "Part Mark" are duplicated.

I've tried several Countif statements with no luck.

=COUNTIFS([Part Mark]@row, [Part Mark]1, [Job #]@row, [Job #]1) worked but would not continue counting past 1.

Thanks in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!