Unique codes

Itai ✭✭✭✭✭✭

Hey all,

I am trying to create a system that will check a unique code that is entered through a form and display if this code has been used already or not.

I have a formula in the summary sheet that will asses if the code has been used or not:

=VLOOKUP($Code$1, {Z Codes Trial Database Range 1}, 3, 0)

The problem is that I would like the formula to always check the most recent entry but the formula changes when a new row is added at the top of the sheet even though its locked.

Is there a way to lock the formula even when a new row is added?

Any other ideas on how to build a unique code system in Smartsheet would be great.

Thank you,

Itai Perez

Project Manager | Transformation Department

Gong cha

If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!