Populating values in newly added column for existing rows

Added a new column(Not Virtual) to the table with existing entries, the column has an app formula which uses the value of one of the columns. If i make a new entry it is working. But how do i populate to the pre-existing entries.
Any help is appreciated.

Thanks in advance!

Hi @Mayur_RJ
What is the formula you are using?

There’s no trivial way to do it. You’ll probably want to use actions to do it: one that identifies the rows that need to be updated, and another that updates them. If there a lot of rows to update (say, more than 100), your actions should be run as a report.

See also:


Or you could do it in the sheet and copy paste values.


Thank you Steve! That is a workable solution in my scenario.

1 Like