- How do I add comments in automated email alerts?
Hi all, I've been working with my sheet on sending automated emails to contacts within the sheet and can add specific parameters for what is in a cell. However, I can't figure out how I can display the comments in the email without having a link to the form. The reason I don't want a link to the form is because these…
- Does deleting information from a cell not count as "when a row is changed"?
Hello, community, I have my automation trigger set as "when a row is changed" in a certain field, but I noticed that deleting information from that field does not trigger the automation. Does information removal somehow not count as a "change"? If not, how do I set an automation when only certain fields are deleted (not…
- Copy Row to overwrite formatting/Formula
I am trying to create a new sheet from a template in Zapier, (which is working fine). But I am next trying to copy a row from a "Master" sheet to that newly created sheet. It does create the new row, however it is always one row beyond my pre-filled formulas. In the template I have a formula to read information in [Column…
- 更新请求,显示发送,但没有Received
Hey all - Been using all the great functionality of SS for quite some time now. I have an Automated rule setup so that when a person Submits a certain thing, an Update Request is Automatically triggered. I've had several of our AEs reach out saying they're no longer receiving them, but when I go into SS, I can see that the…
- Copy Row Automation Does not work
Hello all Few months ago I set up an automation to copy a row from Sheet A into Sheet B when the value of a Cell is changed to "Signed" by a user manually. There is no formula driving this cell and the automation is as simple as the below screenshot. The problem is, this automation suddenly stopped working few weeks back…
- Data missing when moving rows?
Hi there, Has anyone noticed an issue with data missing when moving a row from one sheet to another? I have an automation that moves older rows in one sheet to an archive sheet once a month. However, it appears that data in at least one of the columns is missing. Any ideas what might cause this? Thanks! Jackie
- Automation to help with Daily Medical Intake Forms
I am having one hell of a time with the automation to help our school with being alerted to different issues facing out compliance with the Daily Medical Intake Forms. What I am trying to do is have a couple of reports sent but something is not making it run. Students' parents fill out the med form daily. Some of the old…
- Regular project updates
I have a sheet and want to automate a request to assignees to provide an update at the same time each month. How can I do this without a due date and a formula driven checkbox or flag that would trigger the request?
- Approval Sequence Workflow
Hello, I have setup an approval sequence workflow automation. The trigger is "when added or changed". However, I have had complaints from individuals they are receiving multiple notifications and if any of the rows are moved between sheets or cells are changed the approval sequence starts all over again. I need to stop two…
- Can I Automate entering/erasing data from a cell?
Is there a way to set up an automation so the content of a cell can be changed when one or more criteria is met? I have a sheet where I'd like the cells in a particular column to be cleared at a certain time everyday. Is this possible?
