Partial result
Hello,
I'm attempting to create a way to review an account number from one cell, and have a different cell populate just the last four digits with X's for any other remaining characters. So account 1234567 would show XXX4567, where as account 123456789 would show XXXXX6789. Fairly new to complex formulas and not sure where to start with this.
Best Answer

=RIGHT("XXXXXXXXXXXXXXXXXXXXXXX" + RIGHT(account@row, 4), LEN(account@row))
This assumes max account length of 18 digits. If you have longer numbers, add more Xs!
EDIT to add:
This formula will end with a result that is the same length as the original account number. If you want to fix the length, replace the "LEN(account@row)" at the end with whatever length you want, eg 10.
Answers

=RIGHT("XXXXXXXXXXXXXXXXXXXXXXX" + RIGHT(account@row, 4), LEN(account@row))
This assumes max account length of 18 digits. If you have longer numbers, add more Xs!
EDIT to add:
This formula will end with a result that is the same length as the original account number. If you want to fix the length, replace the "LEN(account@row)" at the end with whatever length you want, eg 10.

That worked like a charm! Thank you
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 382 Global Discussions
 212 Industry Talk
 444 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 291 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!