Skip to main content
Question

How do I add new role to top of Microsoft Excel table?


jamesharnett

I want to add a row from Airtable to an Excel spreadsheet to the top of the table, rather than the bottom (as it is automatically configured to do). Is this possible?

Did this topic help you find an answer to your question?

3 replies

Troy Tessalone
Forum|alt.badge.img+14

jamesharnett

Aw shucks. Is there some way to trigger an automatic sort in Excel so that, let’s say I’m inputting a date (MM/DD/YYY) in a table, the table sorts all of the dates in a given column from earliest to latest, inclusive of the row that was just added?


Troy Tessalone
Forum|alt.badge.img+14

@jamesharnett 

Try using 2 tabs.

One tab for raw data added by the Zap.

One tab with formulas to pull data from the raw tab and sort.

https://support.microsoft.com/en-au/office/sort-function-22f63bd0-ccc8-492f-953d-c20e8e44b86c


Reply