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
-
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 - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
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 - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Thanks, you got it! Thanks for answering me so quickly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!