Best answer

How do I automatically have a Google Sheets formula used from the previous row?

I’ve setup a Zap to check a Dropbox folder for new files.

Then the file name of the file is inserted into a Google Sheet.

Now I need to figure out how to automatically have columns from the preview rows used for the new row.

icon

Best answer by Troy Tessalone 4 January 2023, 00:18

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Userlevel 7

+14

Hi @KevinCrit

Good question.

I may suggest you use Airtable instead of GSheets.

Airtable has Formula fields, and those will be automatically applied to every record/row.

Userlevel 7

+14

@KevinCrit

If you are trying to use GSheets, then check out these related Topics:

Hi @KevinCrit

Good question.

I may suggest you use Airtable instead of GSheets.

Airtable has Formula fields, and those will be automatically applied to every record/row.

Google Sheets is used by our accountants, so it’s not really an option. Thanks for the suggestion.

Userlevel 4

Thanks for the help as always Troy, those are great resources. Let us know if you run into any issues when setting this up @KevinCrit

Sign up