I have to create two fields that contains the name of a project.
One of these fields has to have certain characters removed.
I already have this in the calculation of a field called PROJECT NAME
But what I need to add in this calculation is the text from another field where we type in the full project name with the characters.
So I only have to have type this in once.
The reason for two is that while we like to use characters on invoices...I need to export it as part of a filename. Those characters are not recognized on import into AccountEdge software.
How do I add the other field into this Filter calculation above? I looked through other examples but could not find my situation in the forums.