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!
Thanks. There are three tables in the base but the tasks that need to be updated are all in one table. The task name is manually input. It is copied from a template and pasted into the task table. (this is why it comes in as a generic client/project and needs to be edited with the actual client/project)