-
Help with cross-sheet references
I am having some trouble understanding this. I have a form connected to a large gathering sheet where individual peoples info is all tracked by a 'Unit' or team. I have automations set up to separate each units info from the form to that individual unit (So I have one form collecting 25ish teams form info, and then it gets…
-
Copy rows to create historical data
Hi - I have a metrics sheet that calculates different metrics from other sheets. At the end of each day I'd like it to copy those metrics over to a historical tracker so I can create a chart of how each metric moved over time. This is my metrics sheet I'd like it to copy over to an identical historical data sheet but into…
-
Auto Number column for only NEW rows
Hi - We have a sheet where we are tracking issues, and we'd like it to assign the next number in sequence once a new row is submitted via a form. Below, the "Issue Number" column is the primary column, so I cannot make this an auto-number column. What would be the simplest way to implement this? I cannot include other…
-
Calendar Query - repeating item automation
Hi there Im creating a calendar for my team in SS - some items are repeating Weekly / Monthly / 1st Wednesday etc. How do I automate that rather than having to type each entry individually ? Thanks for your bright ideas 🌟
-
Adding an Attachment from Dynamic View is Not Triggering an Automation
In my Dynamic view, I have allowed users to add an attachment (this is the only update they need to make to the row). In my sheet, I have an automation that is triggered 'when a row is changed' and an 'attachment is added or changed. The action is to change a cell value. When I add an attachment via the Dynamic view, the…
-
Possible to send MS Outlook email Templates once a task is reached
I am trying to set up outbound emails to send to external parties for their deliverables, setting timelines, and forms to complete once certain milestones/tasks are reached with in a project. Is it possible to have a email template built / added and have that template pull in information from the sheet summary such as…
-
Automation Email in Two Different Formats
I saved a sheet as new, in a new workspace, and my automation is working differently on the original sheet vs the Newley created sheet. The automation is exactly the same (Send x row in an email with x specific columns to x person) When I do it on the original sheet it gives me the full row horizontal view that is neigh…
-
Require Conditions to move card from one lane to another in card view
Is there a way for me to essentially "gate" the movement of one card from one lane to another in the card view? Essentially, I have a number of lanes "in planning", "in process", "complete" but I want user to be required to make sure specific fields (columns) are populated before moving from one lane to another… Is this…
-
Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers
Hello all, I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code. The issue I have right now is that, I have the column of 500 coupon…
-
Mysterious strikethrough being added during automation process?
Sheet 1: team manually enters weekly updates to dates and metrics Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2 Sheet 2: ledger of all updates made week to week Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's…