-
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…
-
Help with Charts
Hello Community. I am very new to smartsheet. I have created a dashboard and want to add charts from a sheet. The metrics i want to provide are not numeric-based. How can I create the charts without numbers being associated? Thank you!
-
Data Mesh Error
Hi, I am using Data Mesh for the first time. I am trying to populate my target sheet with a report. There is a sheet that feeds the report. New rows may be added and existing rows will be edited frequently. So, I believe choosing "Copy and Add Data" is the correct choice for Data Mapping Format. I have 2 rows in the target…
-
Workflow Toubleshooting
I'm testing my workflows that have 2-3 approvers each, and the feedback I am receiving is that the approvers are all receiving 10-20 email notifications for the same request. Does anyone know how this might be happening?