-
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?
-
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?
-
Email to Name Automation/function
Hi, Is there a way to change an email, entered into a cell, to the name of the person? I figured that I could created an address sheet and use a cross-sheet, matching/index, formula. However I am hoping that there is a more simple and less time-consuming way. Any information would be helpful, thank you!
-
Can an update request be sent more often than once a day when it is set to be time triggered?
It has to be via time trigger since I have to send multiple rows for updating
-
Workflows not functioning after Smartsheet copy
I created a copy of a Smartsheet that already had Workflows set up. My auto-emails are not sending from this new copy as they were from the original. The settings are the same and each automation is enabled. I even tried deleting and re-adding the recipients but it's still not working. Why could this be happening and how…