How can I make a column only show me the last 4 digits of each cell within a column.
For instance, how can I make the column only show me the last 4 digits within the column itself. So that we can enter the last 6 digits via a Form, but it only shows the last 4 digits within the sheet.
Answers
-
=RIGHT([Last 6 of VIN]@row, 4)
The data entered via the form will be your "helper" column. You can hide it on the sheet. What you'll look at on your sheet will have this formula in it to clean it up to just the rightmost 4 digits.
-
Hi @ivanlopezb
I hope you're well and safe!
Try something like this.
=RIGHT([Last 6 of VIN]@row, 4)
Did that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello, thank you for the responses. I get an error that says #CIRCULAR REFERENCE. I type it into a cell within a column and then switch it to column formula but get that error. Thank you
-
Excellent!
Happy to help!
Can you share a screenshot showing the columns and the error message?
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!