This discussion has been merged.
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…
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…
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…
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…
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…
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…
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…
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…
