I need help with a nested IF AND statement that also uses the SUBSTITUTE formula. I’m trying to automate project ID creation. Each project is tied to a client and can also (optionally) be tied to a different sub-entity. Depending on who is paying, I ...