-
Merged: New automation to copy cell content to another column (for capturing baselines)
This discussion has been merged.
-
Merged: Automation copy from one cell into another
This discussion has been merged.
-
Is it possible to create a trigger from an Update Request?
We are trying to create an automation where every time an update request is sent and submitted (even without any change), an email is sent to our personnel. What is happening is that for that to happen we created a trigger where specific cells when changed send the email to our personnel. The problem is that when a change…
-
Timed Notification
I'm trying to set up an approval workflow for my intake system. For instance, Issue is submitted and worked. I want to notify the submitter that it's resolved and request them to approve/deny resolution. The problem I am running into is the ability to "auto remind" them of open approval request should they not respond in…
-
Automation Workflow run on the 1st of the month
Hi I need to have an automation run on the first of the month based on the approval date and I'm not sure how to do it. For example, if the approval date is done 5/8/23, then the automation should run on 6/1/23. I believe I need to create a helper column that would house the formula to calculate the 6/1/23 date but I'm not…
-
Need help with an NETWORKDAYS formula to pause the day count when a Status is selected
I need help with a NETWORKDAYS formula that will count TODAY() if Escalation Completed Date is blank and pause day count if the Escalation Progress is "Phase 0: On-Hold" and the column for On-Hold Date has a date recorded (and will still count as TODAY() if blank). Current Formula I am trying after searching in the SS…
-
Clickable URLs in MS Teams alerts
Hi there, We use the Smartsheet alerts in MS Teams to let the company know when the editorial team has posted new content. However, the URLs in the alerts are not clickable, even if they are on the source sheets. I understand this is expected behavior. It would be fantastic if we could have clickable alerts in the Teams…
-
How do I stop a time-based reminder once an action has been completed?
Hi, I'm using a Form to pull information about different tasks and using time-triggered reminders for recipients until the task is completed. I want to avoid continued reminders after the task has been completed by using an automation to cancel the reminder, but haven't found a workable solution so far. Any ideas on how to…
-
Assigned Person Changed in Automated Workflow
I created a round robin process that takes the next person on a list of people and automatically assigns a project to them when it is added to a project list. If that person is out of the office, I created an automated workflow where if a project was assigned to them to re-assign it to the next person on the list. The…
-
linked sheet update
HI, I am creating a sheet for our billing department. The sheet is based on the information entered/updated on another sheet. I did link the entire column of the main sheet but the information is not updating when the main sheet updates. As the screenshot below, is the one that I made for the billing department. What did I…
