A column inside a table is using a FORMAT(…) formula which contains a fixed reference to a doc. Something similar to @EmailTemplate. It’s working correctly.
Is there a way to replace @EmailTemplate with a dynamically built reference, so that either @EmailTemplateCold, @EmailTemplateWarm, @EmailTemplateHot would be referenced by FORMAT(…)?
Maybe based on the value in another column (Phase) in the same table that has values [Cold, Warm, Hot]?
So the idea is the dynamic reference can be built similar to → CONCATENATE(“EmailTemplate”,thisRow.Phase)?