Replacing text using excel templates (Conditional Replacement?)
Hi,
So in my excel templates in a repeating group, we need to replace certain text whenever it pops up under a column.
For example.. If <?Customer_ID2?> is "500", we need to display "CompanyABC", else display <?Customer_ID2?>.
Any help would be appreciated! Thank you.
This is what I have already tried(and some variations) but no luck.
<?if:Customer_ID2 = '500'?>
CompanyABC
<?endif?>
It just ends up saying CompanyABC for every line. 'If' condition gets completely ignored.