Formula to change names
Hi there,
I am importing an excel doc and there is a column where I need to change the text.
Original Name | Change to |
---|---|
US Ford Passenger Vehicle Concern NA CRC | PV Concern |
US Ford Truck Concern NA CRC | Truck Concern |
US BEV NA CRC | BEV Team |
How do I write a formula that can change the original names to the shorter names? (see above)
Thanks
Answers
-
I would use an automation instead of a formula. You could use conditional paths that have the original values then use the change cell value action to change to the new values.
If you really want a formula (which will need to go in a helper column) you can use a simple nested IF statement such as:
=IF([Field with original value]@row = "US Ford Passenger Vehicle Concern NA CRC", "PV Concern", IF([Field with original value]@row = "US Ford Truck Concern NA CRC", "Truck Concern", IF([Field with original value]@row = "US BEV NA CRC", "Bev Team")))
-
Thank you Adam,
How do I create this type of automation?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!