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.

Page 1 / 1

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.

@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.

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