-
Modified Date(auto populated by system) get changed for all record without any modification in sheet
Hi Team, In my smartsheet, Modified date which is an auto populated/system generated column, gets changed automatically for ALL the records even though we are not doing any changes in any of the records. This is causing issue in our workflow. We have defined modified date as the trigger point of our workflow. As a result,…
-
Checkbox workflow just stopped working...
All of a sudden, the below workflow is not working. I have tested and demoed this functionality many times and it has been working great—and then Tuesday morning it just wasn't working anymore. In the automation tab, it is showing the workflows as having been just run (see below) but the checkbox not actually being checked…
-
Automated moved cell function
hi. I’ve been playing around with moved cell automation. is there a way to only have the data only move. It’s moves all the colours and fills that are in the previous sheet across too. It’s kind of annoying and mucks up the colours in the new sheet is there anything that I can do to send only data across. Chris
-
Automations using Conditions
Hello everyone. I am trying to create a useful automation for an inventory sheet. On the Sheet I have columns "Qty on Order" and "Qty Rec'd". I am trying to create an automation that will alert me if Qty Rec'd is less than Qty on order. How would I go about that? If I set a condition "Qty rec'd is 'less than'", it wants me…
-
Attributes
Hello Community! Got a couple of questions. I'm trying to set up an automation to send an automated message to the contact recipients on my sheet once the "assign" checkbox is checked. Is there a character limitation on the body of the message? Someone on my team indicated that the message is being cut off so I'm gathering…
-
Looking for a way to auto fill the Label and Description on a form
Is there a way to quickly customize label and descriptions on forms? Like for example reference the field that contains the label and description information so it populates based on the primary value. Example I'm using the form as a voting ballot for prioritizing issues. The primary key is the Issue number then there is a…
-
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…