-
Move or copy row workflow results in empty rows in destination sheet
I have set up a few workflows that copy rows from an interim calculation sheet into a destination sheet for history/time series purposes. Whenever I set this up, I run a few test cases to make sure it working okay before I let the scheduled workflow take care of this automatically. This means, I have a few test rows that I…
-
Calculate total of each entry from multiple drop down selections.
I have a database which is filled by clients through form. In Area column, the clients will update the area from their house where the issue is located. It is multiple selection. Screenshot attached. In my metrics sheet, I want to find out the total number for each entry. When I put 'countif' formula, it only considers…
-
How to have a report exclude certain items
Hi, I'm trying to build an action item report that only shows approved items that do not meet certain criteria. So in the smartsheet, there is a check box for a document attached and several columns for links to other places. I would like to have the report include only items that are marked as approved (a dropdown column)…
-
How do you pull information from the selected sheet when building a project using Control Center
Here is the situation: We have setup Control Center to build a project workspace from sheets. There are also several dashboards and a separate summary sheet. We are pulling information from the separate summary sheet into the dashboard. A number of other sheets (currently 5 but this will grow) have been identified as a…
-
Resource Management Tool
I'm looking at how I can migrate project plans (Omniplan) into Smartsheet to then use the resource management element to see people's capacity and adjust the schedule to smooth delivery. Has anyone done something similar or have any learnings they can share with me please? Also, attached is a screenshot of the resourcing…
-
Row and Sum calculations for Capacity Management
So, until we get 10k feet, I am trying to figure out how much of our team's capacity is spent on projects or operations work. In the sample below, I'd like to know how much time teams and sub teams spend on Projects, Operations, Enhancements, and Admin. There may be muliple project, operations, or enhancement rows. I'm…
-
Alert based values in two columns
Hi, I have a total inventory column and a reorder point column. I'm trying to make my sheet alert someone when the inventory falls below the reorder point. I can't seem to figure out how. I know I'll need a helper column. I thought I'd do a check box and then have the alert set to when the checkbox is checked. But I can't…
-
Moving rows to new sheet with proofing enabled
It is very inconvenient that I am unable to move rows that have proofing enabled to a new sheet (keeping the proofs intact in the new sheet). We have purchased a new company and we need to move those company-specific rows to a new SmartSheet (including the proofs) but we are unable to do so. Is there a work-around solution…
-
Form Dropdown Help
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on each category (all numbers don't have to be used, but they can be). I want the form to…
-
Updating (e.g. formatting) Sheets - Is there a better way?
Good Afternoon! I am 2 months new to Smartsheet and enjoying the journey thus far. Project Background: I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Master template which contains alot of formulas and conditional formatting, etc. Once I get it designed as…