Scenario 2 work sheets Sheet1 Tasks Tasks can be added and deleted Columns Name Date Email Task Description Sheet2 Running Total Columns Name Email Running Total Help needed Every time a new task is added in the tasks sheet Check whether the row exists in sheets2 identified by email, if…

Jason, I have a way for it to be done using Zapier. Trigger a ZAP when a new row is added to Sheet 1. Find the corresponding record from Sheet 2 using a combination of Name and Email. You may have to create a helper column that combines name and email in both sheets. Update the record to incremen…

Thanks good suggestion. I did think about using Zapier but was wanting to avoid using 3rd party solutions :slight_smile: there must be another way :slight_smile: :grinning:

What if you didn’t allow actual deletions, but just add a switch to remove the task from the list. This would preserve the spreadsheet entry, but remove it from view in the app.

Yeah already do that thanks. Trying to preserve my rows as they are building up quickly even on my pro account. I could condense 1000 rows into 1 if I allow delete. Thanks

What if you used a Query to create a new sheet that only contained items that aren’t marked as deleted and use that sheet for your app instead? Just trying to think of non-Zapier or script methods for you.

Ideally I didn’t want to create a new sheet, just want a new row added to other sheet and increment by 1. There must be a way…I’m sure. Thanks for the suggestion though

I think there will be at some point. [image] What Actions do you wish Glide had? Feature Requests Hi all! At Glide we are starting to think about how we are going to make it possible to make more powerful actions when users are interacting with your app. I’d love to hear …

Thanks, yeah agree script is the way to go. Just got to figure it out…wish me luck (I need it!) cheers :beers:

Here’s one quick way of doing it with G.S. commands/formulas away from needing google scripting or other tools: [image] Formulas used in Sheet=Running: In A2 Cell =arrayformula(if(B2:B<>"",vlookup(B2:B,Tasks!A:B,2,FALSE),"")) In B2 Cell =arrayformula(unique(Tasks!A2:A)) In C2 Cell =arrayformu…

Thank you, I am gonna try and have a go with this on Monday, wish me luck :slight_smile:

Google Sheet Formula gurus I need help

Ask for Help

Rosewebstudio September 14, 2020, 6:09pm 18

All tasks per user, thanks

Topic		Replies	Views
Use Increment in a different sheet Ask for Help	6	1177	May 3, 2021
Formula create on new ron insert google shgeets Ask for Help	2	224	March 23, 2023
Add row to a diiferent sheet using data from this sheet Ask for Help	1	364	February 23, 2022
Alternatives to zapier Ask for Help	13	1399	November 3, 2020
Scripts, scripts, scripts! Ask for Help	240	10545	January 4, 2022

Google Sheet Formula gurus I need help

Related topics