Using IF/THEN to Create a Password
I have a sheet to track password-protected documents and currently have a formula to automatically create a password. However, I would like it to create a password only if the document will be returned via email.
The formula for the password is:
=RIGHT(ID@row, 5) + LEFT([Last Name]@row, 4) + [Year of birth]@row.
How would I use the IF function to populate the password if the Return By is "email" and but leave blank if another choice is selected (in person, or mail)?
Best Answer
-
As soon as I hit "Send" on this question, I figured it out! The correct formula is:
=IF([Return by]@row = "Email", RIGHT([DL #]@row, 5) + LEFT([Last Name]@row, 4) + [Year of birth]@row)
Answers
-
As soon as I hit "Send" on this question, I figured it out! The correct formula is:
=IF([Return by]@row = "Email", RIGHT([DL #]@row, 5) + LEFT([Last Name]@row, 4) + [Year of birth]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!