Help

=ROW() equivalent or workaround?

Topic Labels: Formulas
942 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ian_Plotner
4 - Data Explorer
4 - Data Explorer

Hi

Basically, when a row is reordered in a view, I need to update the “Last Modified” field. Since it does not update on its own, I want to use something similar to =ROW() so that the record is automatically modified with the new row number and thus the Last Modified field will also update.

That’s the best way I can think to do it but I’m happy to hear other ideas!

1 Reply 1

Welcome to the Airtable community!

This feature does not exist and is unlikely to ever exist. Airtable rows are unaware of their relative positioning and thus cannot take action based on changes to row order. A change in row order is not a data change. This is in part because records can appear in different orders in different views.

If you can identify the specific data change that causes a record to change position, you might be able to run an automation that updates a field in all affected records. This would likely require scripting.