-
Rows Weighted Differently for % Complete of Parent Task
We have a bunch of tasks in our smart sheet timeline that are weighted differently to determine the percent complete of a parent task. Am I somehow able to say that row 5 is only 20% of the parent task, but row 6 is 40% of the parent task, and have that calculate towards the total percent complete of the parent task…
-
Using COUNTIFS to automatically assign new rows to a person based off criteria
Hey all, I am working on a way to automatically assign newly added rows to a sheet based off a certain criteria. We have two managers. I'd like new rows to automatically assign to one manager then the other based off different scopes of work from a multi-select column. For example, I can only input 8 types of jobs and 8…
-
One Row - Multiple Actions with Different Owners
Is it possible to have one row, with multiple actions where the automation only goes to the appropriate action owner? For example, we do an intake of information (let's say IT issues) and with every IT issue there are actions identified and a corresponding action owner for each action. However, we don't want people to have…
-
Iterative Functionality (circular reference) in smartsheet.
I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built into automation tools. The specific situation is that I want to track how long a card…
-
Have there been updates to automation?
I've noticed recently that automation doesn't seem to be working... have there been any updates/changes recently? A basic workflow to update a cell value is not working: This workflow has been working without fail for nearly a year, and now all of a sudden, the cell value is not being updated. I cannot say how long this…
-
Clear cell automation is not working
Hello the automation I created has a row copy to another sheet and then it's supposed to clear some cells. Currently it copies the rows but does not clear them. I have the exact same automation in a copy of this smartsheet and that one is working. Any idea on why this doesn't work? This sheet has about 20 additional rows…
-
Recording dates in single workflow
Hello Everyone, I hope you are doing great I am trying to record 4 different dates in a single workflow but getting dates in only in the 1st date column and all the 3 date columns are not working. In my sheet I have 4 different status columns and their value is (Not Started, In Progress and Complete) Status 1 - Not…
-
Automated Directional Arrow Symbols
I am trying to compared two columns in my sheet, based on if the numbers in the column grew, shrunk, or were unchanged. I'd like to automatically show this with the up/down/unchanged symbol. Is this possible? I was able to get the up/down arrows to automatically show, but I'm not sure how to incorporate the "unchanged"…
-
Automatically Send Responses on Form
Hi, I have a Form that a variety of Managers use to input data. Is there a way to automatically send their responses on the Form to them after? Or do they constantly have to check the "send me a copy of responses" button each time they submit something? I tried to setup an automation for it, but I am not sure how I would…
-
find zombie automations
As we've been developing a fairly sophisticated control center project we have been archiving our alpha versions and unfortunately not remembering to turn off the automated workflows there. I think I've found most of them, but I'm wondering if there's a way to see a list of automations for all of the sheets for which one…
