I’m trying to apply smart makers for excel. and in specific cases I need to insert static value (header) with some dynamic value (date)
for exmaple:
Cell A1: &=$translation_report_date: &=data.fromDate - &=data.toDate
exmaple output: Report dates: 01/01/2022 - 15/01/2022
there is any way to achieve that?
Adding multiple Smart Markers in single cell is not supported. But you may workaround to merge data as data source. For example, in A1 and B1 cells (for individual headers), you may insert markers like “&=t.header1” and “&=t.header2” respectively. Now in C1 cell (for combined headers), you may insert dynamic marker like “&=&=Concatenate(A{r}, “-”, B{r})”. Alternatively (if you do not want to use dynamic smart markers (formula)), you may merge in code accordingly.
Hope, this helps a bit.
yes, thank you very much, will go via the code 