-
Microsoft Teams Notifications Are Disabled - Change in Behavior
I have a user that has had automation set up to send notifications to a Teams Channel working for some time. It suddenly started giving an error: "Microsoft Teams notification are disabled. Your System Admin has disabled Microsoft Teams notifications for your organization." The sheet permissions are Unrestricted and the…
-
Smartsheet Automations and API/Webhook Calls
Hi there, We have a sheet then when an item in the sheet is marked as complete it is moved to an Archive sheet using Automation. The problem is there is so much data in a short period of time that we hit the sheet cell limit and have to export the data out into a CSV. I am wondering if there is a way using automation to…
-
Deactivate Automation Per Row
I have a super useful automation triggering on a daily basis if conditions are not met. However, I don't want to annoy the user by pinging them (7) days a week with the same automation since the condition remains unfulfilled. It would be very useful if I could turn off the automation per row, similar to being able to…
-
How to create if/then formula to identify differences in text columns
I'm trying to automatically identify whether PIs in my departments are collaborating on various projects. I'm essentially looking for a formula that will identify in a column when up to 4 departments are not equal. Suggestions?
-
Control Center - Destination Sheet change dynamically in Copy/Move Row Automations
I have a sheet in my blueprint that I want to copy rows from to another sheet in the same blueprint. When Control Center spins up projects, I want to be able to have the destination sheet change dynamically so that it's going to the selected sheet within the new project toolkit and not my original blueprint. See this…
-
Automation Deleted, Messages Continue.
What can I do about an automation that has been deleted and continues? I had a reminder automation to be sent out every so often, the automation was deleted and continues to be sent even to individuals no longer shared to the sheet. Beyond the automation menu is this something that I will have to contact support for or is…
-
Why would a formula work on one sheet but be #unparseable on another?
Hello All, I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable. This is…
-
Helper sheet no longer populating
We have a helper sheet that absorbs certain orders, entered by a form, to fill another sheet. It is no longer populating. The only thing I know has changed is that some column names on the main sheet had been altered in order to set up an automation for a totally different sheet. Nothing else appears to have changed. Would…
-
Copy a date in a cell that is formated as a date
Hello everyone, i have a layout where project managers fill in all relevant information into an intake sheet. And then i have created some formulas and automation so that the project sheets would fill themselves upon creation. So far so good. Now I have different date columns in the project sheet that need to be filed in…
-
How do I include the parent row of a task that is being triggered by a condition event of the task?
My project timelines are separated into parent / child relationships, with the description of the component in the parent row, and the description of the task in the child row. The child row is triggering an email to the project manager based on the condition that the end date is in the past and status in not completed. I…
