-
How to figure out which Workspaces have scheduled backup?
Is there a way (other than going one by one) to figure out which Workspaces have been configured to have scheduled backups? Smartsheet team -- It would be great if there can be a visual clue against the Workspace that indicates if the Workspace has a recurring backup scheduled or not.
-
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…
-
How to manage many identical Smartsheets?
I have been asked to develop a group of 70+ project trackers for departments. Columns: Task, Sub-Task Category Percent Complete (roll-up) Start Date End Date Status Each of the 70+ unit project trackers will dashboard. Each of the 70+ trackers will contain ~50 tasks. The columns are to be identical across sheets, but may…
-
How can I capture a date ONLY the first time a certain status is used?
Using 'Record a Date' workflow based on a "status" that may get used multiple times during the process. This results in the Start Date (recorded date) getting overwritten each time that status is used. How can I capture a date ONLY the first time a certain status is used?
-
How to autofill a cell with an incrementing number for each time a value appears in another column
Column formula request: I'm trying to assign a numeric value to a cell and increment up for each instance a code shows up in another column. For example, if a column has NH002 in it 4 times, the first time, the cell should have a value of 1, and repeat until it gets to 4. Once NH003 starts, it would start over at 1 and…
-
Recurring tasks
Hi all, Our director is hoping to start a Smartsheet that lists our recurring annual/semi-annual/biennial tasks, and sends reminders as each due date approaches. I don't anticipate it being difficult, but... My "work smarter, not harder" mind wants to find a way to automate the recurrence. For example, if our annual audit…
-
Multiple IF THEN outcomes based on combination of drop down values from 2 columns
I've looked through a number of formulas in this community, but can't seem to find one that works for my application. I am trying to build a Stakeholder Register sheet. Based on the values from dropdowns in 2 different columns, I want to populate a 3rd column with one of four stakeholder engagement strategies (Engage &…
-
Number of Open Task
What formula should I use to get the total number of OPEN task. I know it's open if 1. the box is blank, task has not been assigned or date has not been entered under Date Completed.
-
Create an alert only for form submissions (not for all added rows)
Hello, I have a sheet that has all my project tasks in it. I just created a form that I want to use to populate requests on the same sheet. I need to create a notification alert JUST for the form submissions. I don't want to get notified every time a row is added to the sheet b/c I am constantly adding things to the sheet.…
-
Looking for some help with barcode functionality
I see Smartsheet can use barcode scanning in the mobile app, but I can't find any good information about how to use it. What I would like to do is have a setup where the person at the end of our assembly line can scan a BC on packages to enter them as complete. Our packing labels have a code on them that consists of the…