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...
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 ...
