Formula to workflow a form submit that duplicates another entry

Marc Meilert
Marc Meilert ✭✭✭
edited 11/18/20 in Formulas and Functions

I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted.

I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the submitter of the other existing configuration (Row identity)

I have 6 columns of information to verify against.


Hopefully this functionality will be added to smartsheet eventually.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!