-
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…
-
Need an automation of 'One week before' instead of 'When a date is reached'. Is possible?
Hi, I'm trying to do an automation of alerting a person in the team when the actual date is one week prior to a 'start date' column. I thought this would be super-easy, but frustratingly, smartsheets automation option only allow 'when a date is reached'. I'm surprised they don't run more options eg '7 days before a date is…
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
Workflow for Tracking Inventory Counts and Bin Locations
Hi, I am trying to setup a sheet to keep track of when we count bin locations in our warehouse and how often. I would like every bin to be counted at least once ever 12 weeks. In our bin locations column, I have a multi-checkbox setup with all 403 of our bin locations in it. We typically count 5-12 bins a day. Can I setup…