Hello,
I was trying to update a column if blank/null by referencing other rows which fit certain criteria. I think this could be accomplished through Multi-row formula tool
In the example in attachment the logic would be:
If LT column is blank then populate it with the LT value from row with:
-Same 'Indication', Same 'Brand' and 'Country'
-Else Same 'Brand' and Country'
In my real data there may be multiple rows that satisfy those conditions. the row to pick the data from can be arbitrary.
Thank you in advance.
Let me know if not clear enough.
Kind Regards,
Joao
