-
Dependencies on GANTT view
Hi, I am struggling to get sub tasks report as I think they should. Example in screenshot. Basically, if I have sub tasks, then I want to have the heading task report the last date when ALL the tasks are complete. At the moment, by default, the main task shows when ANY date is entered in "Finish" which if sub tasks are…
-
Multiple Projects - Resource Overview
Hi, we are using Smartsheet for managing our Sales Pipeline. As soon as a project is ordered, we are using the same line to gather project information related to execution. I would like to add a Gantt Chart to each lien (via Hyperlink to another Smartsheet) in one cell with resources. Question: I would like to see a…
-
assigning fields when setting up a JIRA to Smartsheets workflow
HI, I have an end date field in my smartsheets workbook. When I setup an workflow to import from JIRA I am unable to find the end date field in the drop down table as below does anyone know why this is?
-
Yellow rows.....
Can someone help me understand the why the yellow colored rows are showing up? And how to fix it? I think it has something to do with dates but cant seem to figure it out. See the attached screen shot. Thanks much.
-
Setting up Alerts
We are running a number of different projects on a sheet that have a: 1) - Delivery Deadline (which is specified by the client), 2) - Delivery Date (which is set by dependencies on our Production Schedule) When Production is running late, the Delivery Date can end up later than the deadline. How can we set up an alert to…
-
Bringing a Smartsheet Gantt into Adobe InDesign
Any suggestions for how to export a CRISP image of a Gantt chart from Smartsheet such that I may feature it in an InDesign-produced proposal? I get blurry pdf files and very low-res tiffs. The best I've found is a screengrab which still isn't very sharp.
-
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…
-
Recurring Tasks Set Up
Is there a way to set up a task that happens every quarter or six months without having to enter the task 4 times in each year?
-
Changing the Color of a Parent Task Bart in Gantt Chart
Smartsheet, It would be nice to be able to change the color of a parent task bar in the Gantt Chart. What is the reason for not being able to do this? I did find a comment (https://community.smartsheet.com/discussion/cannot-format-milestones-summary-bars) that says if dependecies are turned on, then gray is the default…
-
using IF together with AND
Sorry in advance if this has been answered but I have searched and cannot see the answer but I am sure its simple! I have target finish and actual finish columns, in the status column, I want to report "in progress", "overdue" and "Complete" I have got "in progress", "overdue" to work by the following: =IF(TODAY() <…
