Formula needed for duplicate form entry

Stacy Bobbitt
Stacy Bobbitt ✭✭
edited 02/21/20 in Formulas and Functions

I am new to Smartsheet and can't find a solution to my issue. I created a request form to have Professional dues paid and I want to write a formula to have the new line entry look at the preceding entries to see if the employee's name is already there. I've tried a countifs and a join formula but neither are doing the job. Any help would be greatly appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!