I’m struggling to get the desired results using the Substitute formula. Maybe I need to try the Replace formula. But thought I’d ask here in the meantime.
I have a list of tasks. Each task starts with a client code and project code. How can I write a formula to update the client code and project code for each new client/project?
For example, if the one task is “CLI-PRJ-Send thank you to client.”
I would like “CLI” replaced with “4CR”
I would like “PRJ” replaced with “Blog”
So the new task would be “4CR-Blog-Send thank you to client.”
Thanks in advance for help on the topic!