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
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!