-
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 Centre Automatic Move Automation Rerouting
I have a Control Centre Blueprint that contains two sheets, let's call them Sheet A and Sheet B. Sheet A has a Move Automation that sends the row to Sheet B. I would like it to be that when Control Centre provisions a new set of sheets, let's call them Sheet A' and Sheet B', the provisioned automation on Sheet A'…
-
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…
-
Why are my workflow notifications not coming over as my name via Smartsheet?
I have my automated workflows set up to "send from triggering user." However, I have made a few updates, as well as others who have triggered the workflow, and the workflows show in email as from "Smartsheet Automation" instead of from "triggering user name via Smartsheet". I have been playing around with it but can't…