I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual.
I want to count how many of t…
Formulas and Functions20Martina Barnett
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet40Mary Vogt
I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is m…
Using Smartsheet11Phil Schmitt
I am trying to build a nested at risk formula based on the following triggers.
-End date is today and Status is not complete it will trigger
-There is not enough time between today and the end date for the duration period left. So, if dura…
Using Smartsheet21Kayla Johnstone
Anyone else seen this? Not sure if it has been like this since the start or if its a new thing...
Is there a setting to correct this?
I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year.
Here is my formula that calculate 0 every time (at least not an error) :
Formulas and Functions22Assaf Elad
I am attempting to use conditional formatting to change the color of my Gantt bars; however, the conditional format is not being applied to the Gantt bars.
Here is my conditional formatting
You can see below that I specify…
Using Smartsheet25michael anderson
When I select Gantt view some of my child tasks have work day and non-work day shading. Non-workdays are light grey and work days are White. This occurs randomly on the sheet. Several child rows have no formatting and some have the gre…
Using Smartsheet18BJ Patnode
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column wit…
Formulas and Functions18BJ Patnode
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions127Alexander Wirtz
I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet.
The strange t…
I need to import an existing project plan (call it A) into an already project plan (call it B).
A is under a different corporate account than B.
I have access to both. I need to merge the 2 project plans into 1. The question probably has b…
Using Smartsheet26Francois Chagnon
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but…
Using Smartsheet150Project User
I am a fairly new SS user and am owner/admin for a large project/Gantt sheet that is shared internally with other Project Managers, who are also fairly new to SS. They have edit permission, but are not admins. I have set the project option…
I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task.
I want to aim for this to detect the percentage of completion of a task in relation to …
Formulas and Functions266Becca Grunbaum
Created a report and added the report via widget to the dashboard.
Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height.
The report itself looks good and correct - the change is o…
Using Smartsheet25Gottfried Reichl Mueller
I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that c…
Using Smartsheet24Ron Schaefer
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a
0.5 story point = 1d,
1 story point: =2d
2 story points = 3d
3 story points = 5d
Premium Apps and Integrations104NKH
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and t…
Using Smartsheet74James Pflueger
Is there a way to color code tasks in a gantt chart that occur during a specific time period? For example, I would like all tasks that are in progress during the months of May, June and July to show as red. I see that I can set conditional…
So...any creative ideas for how to achieve something similar to the attached image IN Smartsheet?
We want to visual represent high level deliverables across multiple projects for the entire year by Month, however, NOT in a Gantt view and w…
I have a need to be able to highlight if a range of dates falls between any other range of dates.
I have a checkbox column which needs to be ticked if a range of dates conflicts with other range of dates.
So for example, we might…
Formulas and Functions134samanthabooty
I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additiona…
Formulas and Functions81Nick Monroe
I am trying to change the drop down value on my Health column based on the current date. Is this possible?
ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.
Formulas and Functions87TRach
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions50KDub618
Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'? We are tracking key milestones and are only provided the End Date. I'd like to reduce the manual entr…
Formulas and Functions33ilene_healy68056
I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call.
Also, includes …
Formulas and Functions33Chuck Perez
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where al…
Formulas and Functions50bukkymoh01
I would like to apply smart sheet to my workstation for daily manufacturing status board.
Is there any chance for me to change gantt chart scale from date to time.
Archived 2016 Posts42Junho Kim