-
Invalid Operation Error on Dashboard but not on Report
Hello, I am using the Smartsheet Dashboard to communicate production status to colleagues. I have a widget on the dashboard meant to display the overall status of the manufacturing run by pulling the status of the last item on our task tracker (Condition37). The tracker is displaying the correct status, in this example…
-
Is there a better way to get the results I am looking for?
Good afternoon, all! I have been tasked with creating an in-depth catalogue of SKUs for my company. Currently, I have a set up that works but is going to be very manual with change management. I have one sheet that is my data dump. It has all of the information located in one spot. I am then going to need to pull this…
-
Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?
-
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions will…
-
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
-
Request for PTO Process
I am working on a PTO process for a large team. I have a request form, goes through an approval process, upon approval processing team member receives notification, calendar (using Calendar Addon) is available for viewing by managers. My question is I would like to include an automated way that team members can either…
-
How to automatically consolidate data from sheets in multiple workspaces into a single master sheet?
Hi Our structure is such that we create a new workspace for each project that we sign on. Within each workspace, lies a sheet with assignee name(s), department(s) and start/end dates for the project. We want to roll up the data from across all project workspaces into a single master resource tracking sheet, and keep adding…
-
Allow Drag-and-Drop Reordering of Summary Sheet Formulas
Currently reordering formulas in the Summary Sheet requires repeatedly clicking the three-dot menu and selecting "Move Up" or "Move Down" for each formula. This process is tedious, especially when managing many formulas. A drag-and-drop interface would make reordering much faster and more intuitive.