Best answer

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

  • 3 January 2023
  • 4 replies
  • 102 views

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

View original

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

4 replies

Userlevel 7
Badge +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.

https://support.airtable.com/docs/formula-field-overview

Userlevel 7
Badge +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.

https://support.airtable.com/docs/formula-field-overview

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

Userlevel 4
Badge +7

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