sdowney
I have created a spreadsheet to track completed tasks. For some time now, the automation I created to record a completed task has been adding a row for every project rather than recording the completed task within a project.
I have defined a "Team" called "Vehicles".
Within that team, I have listed all of the vehicles in our fleet as "Projects".
Each project has a list of tasks such as "Tire Rotation", "Oil Change", "License & Registration," etc.
I've defined an automation with a "Task Completed" trigger. I've also specified the project (vehicle).
The action is defined to insert a row on a Google spreadsheet with text matching the project name and adding the "Task Content".
I created these automations over a year ago and, it seems some of the updates have added features that have altered the process as to what I intended.
I attempted to create a single automation that would add to the spreadsheet in the way the system appears to work now but, I can find no way to include the project name legibly. I've tried all of the "@" functions and there is not one that allows for the project name, the "Project ID" function is a cryptic jumble of characters that means nothing to the spreadsheet user.