-
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…
-
How to Auto-populate form with Request Number
Hello, I am creating a form for customer's to input data into our sheet. This form currently asks for "FER Number" which the customer is currently requested to input. However, I'd like to make this "FER Number" auto-generated/auto-populated. I'd like the form to reference the last input "FER Number" on Smartsheet (bottom…
-
Workaround for Voting
Hello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have a link to a dashboard where they could look at requests that have already been…
-
Automating RYG if a date is too far past another
I have two columns "Date 1" and "Date 2", I want to have a formula for the status column using the RYG Status balls that will: - Green if Date 2 is less or equal to 10 days past Date 1 - Red if Date 2 is more than 10 days past Date 1 Please help
