we are facing a problem regarding the rule engine in the XLS formatter nodes.
For one report, we would like to give a tag to all cells of the rows that have a certain value written in one specific column (in this case “Additions” written in the 4th column). So far we have only encountered the possibility of basing the tags dependent of the Row ID’s column value, but not the value of “normal” column located in the middle of the table.
Please find attached an example XLS File to illustrate how we would like it to look like in the output file.
We appreciate any kind of help! Thank you very much in advance & happy automation!
Example.xlsx (10.2 KB)