Verifying Created by Column with Manager Email Column

Verifying Created by Column with Manager Email Column

I'm trying to show verification for a contact email address to match the "Created by" field generated by Smartsheet to ensure an entry/request is valid/accurate. Can someone help me out with this? Essentially flagging people with inconsistent data.

Thanks so much.

Best Answer

  • RamziRamzi
    Accepted Answer

    Hi @Don Williams,

    If I understand you correctly, you want to make sure that someone enters their email address correctly by having it match the email address in the Created By (system field). If this is the case, try this:

    . Create a column to capture the manually entered email address

    . Add the Created By system column

    . Add a "flag" column to show when there's an error. In this example I added a symbol (flag) column called Error and put the following formula in it: =IF([Contact Email]@row = [Created By]@row, false, true)

    I hope this helps.

    Cheers,

    Ramzi

    Ramzi Khuri (www.cedartreeconsulting.com)

Answers

Sign In or Register to comment.