-
Automating weekly report
Hello, I currently am trying to automate a process but having few issues:I currently send out an email manually to send their top 3 accomplishments, top 3 issues for last week etc. I am trying to automate the sending out email. I want to keep the historic data but do not want multiple columns with each week. Is there a way…
-
How to have a date dynamically changed based on a value in another column?
I'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet titled Sprint #. I'm having trouble figuring out how to tie it all together. I've been…
-
Avoid automation sending same email to contact listed on multiple rows
I have set up a sheet that lists every web page on my company's site and has a column listing the Content Partner who is in charge of that page. I have a workflow that alerts the Content Partner annually to review their pages. Often, one Content Partner will be listed for multiple web pages in any given month (because they…
-
Move row automation with a full destination sheet
Can anyone advise what happens when you have move row automation running but your destination sheet is full? I assume the workflow stops until a new destination sheet is added in the automation logic? Many thanks!
-
Automation To Alert of Any Field Changes EXCEPT Comments
I would like to send an alert to someone when any field in the row changes, except comments. How can this be done without having to set an alert for each column individually?
-
Send email Alert to those who haven' submitted their status for the day
Hi, I've been trying to figure out how to create an automation send Alert email to resources who haven't submit their status for the day. Can you help me or suggest on how am I able to achieve this? Thank you.
-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
Values are missing when creating a condition in an automation workflow
Hi - I am trying to create a 'Request an update' action on a workflow, but when I try to create the Condition and select the appropriate values, not all values are available to be selected. Only 4 of the 6 values are available.
-
Update Request Automation - Single v Consolidated messages
Hi, Hoping someone can shine a light on how update request notifications work. I have a list of projects in a sheet which I would like the owners to provide weekly updates for; some have multiple owners, other tasks have only one owner. I've set-up a few automations to test the different messages owners would receive but I…
-
approval when a row is marked complete
I am trying to add an approval when a specific row is marked complete. I do not see a way to do that. I want to add sign-off of a phase when the milestone is complete (eg. Task = QA complete Status = complete) Is there a way to do that?
