-
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
-
Notification when a task has been re-assigned
Hello, I currently have a workflow that notifies individuals when a task has been assigned to them. Is there any way to create an alert if a task is removed/ re-assigned from them? for example task assigned to A is now assigned to B. Can A receive a notification that this is no longer their assignment? I looked through the…
-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
