How to Delimit Cells in Formulas
Hi,
I have two columns:
I want the second column to be delimited (trim) at just the release version. Unfortunately, I'm not super experienced with formulas.
While I was able to get this formula to work for 1 row,
it's easy to see how this isn't scalable. I looked for instructions on trimming and delimiting but all the examples I saw had words that you could filter out.
I tried looking for some wildcard functionality but I couldn't find it. Can someone help me with a formula that will strip everything out of the first column except the last 4 characters for placement in the second column?
Best Answer

Hi There,
You can have a formula in AFO Version and make it a column formula. The formula would be "=Right([Primary Column]@row, 4)". This formula will pick up the last 4 characters of the text in your primary column.
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers

Hi There,
You can have a formula in AFO Version and make it a column formula. The formula would be "=Right([Primary Column]@row, 4)". This formula will pick up the last 4 characters of the text in your primary column.
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!