-
Logic Project Plan
Hi , Need a help on the project plan logic related to Sch Health. The logic i am using on the schedule Health is not showing me the correct result. As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50% Can any one help on…
-
Generate Kanban based on fields in linked Smartsheet
Hi there, Is it possible to link a Kanban to a Smartsheet, so that cards are generated based on various fields? I don't want to change to the Kanban view as already offered, but generate cards dynamically as rows are added to a linked pre-existing sheet and specific fields are checked. E.g. if "Email campaign" is checked…
-
Auto-populating Job Numbers
I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below: If we…
-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
More customizable/specific sharing options
Hello all, I'm new to Smartsheet and am discovering the limitations when it comes to sharing. First, I'm surprised that sharing folders isn't possible. I understand that Workspaces are intended to make up for this but I guess what I'm lacking is the ability to choose specifically what I share within a workspace. What I'm…
-
Show milestones along a row with multiple dates
It is possible to show milestones along a single row with multiple dates per the screen set below?
-
How to have a date dynamically changed based on a value in another column?
I'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet titled Sprint #. I'm having trouble figuring out how to tie it all together. I've been…
-
Webinar recording available: Keep Your Projects on Track with Baselines
Missed the webinar? Catch up on the recording here. Join us on June 3rd for an introduction to baselines, the newest project management capability from Smartsheet. In this webinar, you'll learn how to easily compare planned and actual project schedules, identify critical variance, and accurately report on project…
-
Actual vs target Date
Hi, Need a help if my Start Date is 05/24/2021 and end date is 07/01/2021 and in my project plan sheet say i have a task that start on 06/24/2021 and end on 06/28/2021 .However, that task is already been completed and the actual % Complete has been updated to 60% for that task i want the schedule Health should be turn to…
-
Schedule Health formula not working,
Hi, Can anyone help me with a formula i have three scenario .1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green 3 % complete is less than the expected work to be completed within the time frame it should be Red and status…