-
Is there an ability to set re-occuring dates in the same row? Calendar/Gantt view
I have several rows on a sheet that have a set date/time each month (i.e. first Tuesday of each month). While i have the durations set for gantt view, I do not see an easy way to add additional dates for the same tracked item? Would I just need to have additional start and end date columns added for each month with a…
-
check boxes aren't updating
Hi all, I send out 3 update requests on MWF. The only one that updates is the Monday one. W+F don't update so I don't have any follow-up. I know that they are clicking on the boxes bc I saw it happen. Boxes on the right are: working on it, done, need help. Working on it gets sent with the W update. Done is the Friday…
-
Automatic Workflow Question
I am trying to copy the data from a Business Problem cell to a Project Description cell without impacting/changing previous entries. Is it possible to create a single automation workflow that copies/replicates data from "Business Problem" into "Project Description" in the same worksheet? I tried the column formula route…
-
I need an update request to include and item name and quantity, but only edit the qty.
I need to set up an weekly update request for supplies to update quantities. If I include both the "Item Name" and "Stock Quantity" columns in the request, both fields become editable. I need the item name to remain so the person doing the update knows which of the 98 items on the list they are updating. I tried locking…
-
Comments Field for Automations
When creating an automation, it would be helpful to have a Comments field where you could add context on what the automation is doing, and why it is doing it. This is helpful when you have multiple people that manage the automations of a sheet. Automations are just a bunch of if/then statements like in coding. It would be…
-
How do I create an automated reminder notice for items that are 25 days or more past a date?
I'm sure I'm missing something simple, but I'm having trouble creating an automated reminder that goes out when an item is 25 or more days past the completion date in my sheet. There's a report that needs to be run about a project, but it needs to be run after at least 25 days have past from the completion date. I want the…
-
Grouping Automations
I use many automations in some of my sheets and although there is sorting and filtering options to navigate between them (and I number my automations to help) it would be great to have a function where we can group them into folders or similar for ease of use.
-
Is it possible to clear cell value in a Date column?
I wanted to clear Installation Date column values using Automation. But I couldn't find the column name in Clear cell value action block
-
Merged: Automated Email (Alert) Enhancements - rich text + cc recipients
This discussion has been merged.