Apply an existing formula in Google Sheet when a new item is added by the user

Hi guys,

I want to apply a formula that already exists in my google sheet for previous lines, when someone add a new item.

To be precise:

I want to automatically apply the Google Formula you see in F29 to a new stock the user could add via the Glide App.

I look into the Arrayformula, but couldn’t find any solution that works.

Many thanks

You can try the script here in my post.


Thanks I’ll have a look

@olivier_eldani just wanted to say a quick hello and to welcome you to the community.


Hi @rosewebstudio
many thanks ! I really appreciate it

1 Like


It looks like the only thing keeping you in Google Sheets is the Google Finance formula? We should add this to Glide.