Q: Conditional Copying and sending of rows to other sheet.
Hi there!
Can Logic Sheet create an automation, that:
1) When Cell contains "X", then row is copied to Sheet B. When Cell Contains "Y", then Row is copied to Sheet C. etc...
2) Can Logic Sheet Delete Rows, when two rows have the same identifier, then the older gets deleted?
Last but not least:
Which feature is or will be the coolest one, from your perspective as product owner/developer?
Thanks.
Wei_Sheng
Dec 1, 2024A: Hi thanks for your question.
1. Yes this is possible with the copy to sheet action, you need to set a condition to each move to sheet action.
2. Yes, this can be done with the remove duplicate action.
For the last question, I believe is the HTTP reqeust action which allows you to talk to almost any API and send data to third party services when an automation is triggered. We also have a built in webhook feature that allows you to receive data in sheets and trigger automation. In combination, this will make your spreadsheet some sort of backend for task automation.