-
Work Breakdown Structure (WBS)
Are there any plans to add the ability to display a graphical (hierarchical boxes) WBS? Stephen
-
Formula for taking an average of duplicate rows
I'm attempting to construct a formula for taking averages of multiple ratings from several raters across three vendors. Sheet 1 looks like: Rater - Category - Vendor A Rating - Vendor B Rating - Vendor C Rating Sheet 2 looks like: Category - Vendor A Rating Avg - Vendor B Rating Avg - Vendor C Rating Avg On sheet two, I…
-
SUM and IF In the same Cell
Is it possible to have a cell include both a SUM and IF statement to do the following. (I do not want use a separate status column.) I want to be able to add up several columns (Actual Admin Labour + Actual Engineering Labour + Actual Mechanical Labour) into a Total Actual Labour column and then add an IF statement that…
-
Create Hierarchy Relationship using WBS and Formula?
Hi, I believe this may be a bit of a stretch but I am wondering if it is possible to automatically create the Child/Parent relationship utilizing the numbers or periods in a WBS # column as a way to automatically create the indention. I have built a pretty good process using Smartsheets data uploader to import external…
-
INVALID OPERATION in one column but not the other
Hello, I have the below formula in three columns in my sheet. They are all referencing the same master sheet, same dates, same facility, same units, but different utilization rates. Two of the three columns are working great. The last one isn't. I re-typed the formula in several times, following the other columns' formula,…
-
How to count how many users assigned to in a sheet
Hello, I have multiple projects and each project is in its own sheet. I am trying to create a summary sheet (to later show in the dashboard) that shows how many people are assigned to each project currently. Is there a formula for this or a feature? Thanks
-
Must start / must end date restrictions
Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Project Manager for projects within the administration environment I do have a desperate need Smart Sheet does not cover. It…
-
Unhide row
I need to retrieve a row in a master smartsheet. I can see that row in a report output, but cannot see it in the source sheet. In the master sheet row number jumps from 266 to 268 and it's 267 that I need. On the other hand, you can't hide, and therefore unhide rows as such, the only thing I can think of is that I may have…
-
Need some helps on Workflow
Would like to include multi stages approval in my workflow. How can I tie up the approval process with the amount of purchase? For example: is less than $500 only one approval, if between 501 and 2,000 then I need two approvals. How do I set it up in the workflow? The amount of purchase is a single column in my sheet.…
-
Global Updates - Add new column doesn't display the projects
I created new Columns inside a template and wanted to push these out to live projects using Global Update. When I select "Apply Test" then none of the project [Templates] appear 1. I have already done this once before and the projects did appear at that stage. 2. I have also tried another type of Global Update Update…
