Comparing Smartsheet User Name (Contact) to Modified By in a formula

Hi ...My solution and struggle is as follows :

I send an automated update request to a contact in a column

When the update request is submitted, I compare the submit date(modify by date) to a due date and allocate points for on time submission.

To validate that the contact person and not smsh or admin made the update, I compare the Contact (email) to the modify by as a validation.

My issue is that where contact is a registered smartsheet user the system doesn't recognize the email address as being the same.


image.png

Please help !

Thank you,

Lee

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!