Apply Formula to Filtered/Visible Rows Only

Hi @minos, welcome to the forum!

We do have some wishes for improving the “Apply formula to data” functionality, and the idea to have an option to apply it only to visible rows is a nice one.

Meanwhile, the way I would accomplish it in practice is to start with a filtered view, then:

  • Create a new column.
  • Set a formula there to transform the original column (it doesn’t matter that it applies to all rows).
  • Select the new column, and copy-paste the values from there to the original column. Copy-pasting applies only to the visible values.
  • Delete the new column.
2 Likes