-
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…
-
I need to automate sheet creation
I see the generate document option, but I need to be able to automate the creation of a new sheet from a sheet template.
-
How to trigger dropdown to populate projected completed date based on specific complexity?
I want to trigger these drop downs in the "Complexity" column to populate a date in the "Projected Complexity Completion" once a dropdown value is selected and once status changes to "active". Low Complexity = 2 days Medium Complexity = 5 days Most Complex = 10 days
-
Tracking the Specific Time of a Cell in One Status
Hi all. I am trying to simply and easily track the time in days a cell is in red status (General Health column in picture below) until it changes. Nonetheless, although we can easily keep track of row changes with helper columns, I really cannot figure out how to do so specifically for one cell. Any recommendation on how…
