-
ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATE
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another sheet is feb/3/22, so under Citrix Status 3weeks from the due date will show in that column and so on I appreciate your help Rob
-
workflow automation - rows aren't moving?
Hello, I created a workflow to move rows once a column status is changed to "complete" within any row. But the workflow didn't trigger, even when I manually changed the status to something else and back again, saved, refreshed, tried again. It finally worked when I moved the row to a different spot in the sheet (shifted up…
-
Daily Automated Workflow when a row is changed - each instance or a final state?
If I choose a daily workflow alert to a person when a row is changed, and the row changes 3 times in the day - all in the same cell (like the date due), will the recipient get each change in the daily email or just the last recorded change?
-
How to Implement Dynamic Dropdown among Two Sheets
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for…
-
Unsusbcribe From Notifications
Hey Community, Any way to resubscribe to an alert workflow? The system won't let me add back a user that has accidently unsubscribed. Thank you!
-
Automation for When a Dollar Amount Exceeds
I'm the owner of the sheet. I'm trying to set up automation to notify me when a dollar amount exceeds $400,000 in the column titled MV. I can not get it to work and must be missing something. Here are screen shots. Any ideas?
-
Can you re-trigger an approval workflow?
I have a couple different scenarios that I've run into. The first is that the end user is saying that the approval request isn't coming to them, so they can't approve anything. The second scenario is that the approval goes to a person that they wrongly identified and we need to re-route the approval to the appropriate…
-
Automated workflow trigger not working
I have set up a series of simple workflows to change a cell's value based on data in another cell. If the source cell value is changed to "50%" for example, the destination cell will automatically be updated with the number 5. There are several different source cells being used, some of which are "yes/no", and some with a…
-
Workflow condition starts with < N
We have a use case where an assignee is variable based on an ID 'number.' The ID Number starts with a letter code, and the assignee is IF ID starts with A-M THEN AssigngedTo = User1@domain.com ELSE AssigngedTo = User2@domain.com Clarification: A-M is A through M
-
Is there a way to tell someone has acknowledged a task has been assigned to them?
I am running into trouble with staff who are saying they never received an update request or something along those lines; however, I have an automation that says it sent. Is there a way for the recipient to acknowledge they have been given a task?
