I’ve been trying to figure out how to make this crazy formula happen, but I’ve hit a wall. Can it even be done? Check out below and let me know how you’d accomplish such a thing…

In the base, users select from a list of deliverables via a linked record field that contains everything a client can order for a particular asset (InstagramAd, SnapchatAd, Master, etc.) Each deliverable has a generic file title that follows a specific convention:

Everything between the exclamation points is replaced with information specific to the asset when the deliverable is chosen on the Order table. So the above generic file title auto-generates this asset-specific file title:

Figured it out