-
Formula Help
Can anyone help with this formula? It works in excel but I am getting Unparseable error in smartsheets. =IFERROR(IF([QTY]@row,<>0,[QTY]@row*[Production Rate]@row),IF([Linear Feet]@row<>0,[Linear Feet]@row/[Production Rate]@row,[Sqft]@row/[Production Rate]@row)),0) Thanks for any help
-
How to add new sheets/dashboard to all existing projects on Control Center
I have created/provisioned a few projects on Control Center and realized that we wanted to add couple more sheets and dashboards to all new projects as well as to all existing projects. It doesn't seem like the Global Update can achieve this as it can only edit information within a template in the blueprint source folder…
-
How to "actualize" or transfer dependencies of a completed task?
Task A Task B is dependent on Task A Task C is dependent on Task B For some reason, I was able to finish Task B and Task A was getting delayed. How do I: 1. Extend duration of Task A without impacting dates, duration or status of Task B? 2. Mark Task B complete, such that actual completion dates do not change irrespective…
-
Multi-sheet Kanban
We use a checklist with 340 lines. We currently create a new sheet for each project. We would like to create a kanban that links these projects utilizing the highest level of the hierarchy as the lanes (5 lanes) and the next level as dropdowns in the cards (9 at the most.) The third level is where the actual tasks are but…
-
Attachment Column
Is it possible to change the width of the attachment column?
-
Row Height
Is it possible to adjust the row height? I can adjust the font size but the height dosen't change.
-
Can a form be created using multiple sheets?
If not how can i create a one to many releationship with form data entered by users. IE. One tech to enter several parts on the same order. New at Smart sheets thanks for any help to point me in the right direction.
-
Indefinite Lag Times?
Hi, I am trying to set up some predecessor relationships between tasks that don't have a definite lag time associated with it. I just need the relationship to require Task A to wrap up before Task B. Task B doesn't need to start immediately after Task A is done, but it CAN NOT start before. For example, I am doing a…
-
using a form to input new data means my formula no longer works.
hi, I am using a lookup formula to find prices for specific things. once a form is used and new information is inputted into the top row the formula says unparseable and the [column name]1 changes to [column name]2. I would like to stay as [column name]1 even when new information is put onto the sheet. Please can someone…
-
Delta/Slippage Formula
I can't seem to get the right formula together in my Active Projects Master Schedule to show the Delta/Slippage in the construction schedules. I have individual columns for Original Finish (Date), Current Projected Finish (Date), and Change Order (CO) Days that are populating dates and numbers with cell linking from the…
