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.
Please help !
Help Article Resources
Check out the Formula Handbook template!