I am currently trying to sort out a spreadsheet with the ‘for each row’ and i would like to seperate some of the rows from others using the ‘if’ function.
currently i am using
[row(“date”).ToString.Contains(date) AND row(“payment”).ToString.Contains(number)
This will give me the rows that have the exact date and number but now i want every row that contains the exact date BUT must not contain that certain number.
How would I rewrite the condition?