-
Highlighting Gantt Chart Date Columns
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspension period. Is there anyway to do that? If not, can I submit that as a feature…
-
Planning Calendar conundrums
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 trying to figure out the best way to handle that. Would I only be able to do it using…
-
Lock Gantt view date on Dashboard from a report
Hello, I am pulling data into a report and displaying on my dashboard. The gantt view always starts on March 15th. Executives viewing the report want to have it start on today's date. The both the source sheet and report's gantt view is checked to start at today's date, but it doesn't translate to the dashboard. I don't…
-
report: take over colors in grid view of a project
Hello, her's my build. I have a project file (file 1) with all details of different project but always with the same structure with different colors. Out of that I created a second PM file (file 2) with links to that main Project file (file 1). --> Until now all fine thanks to the "link from other cell of sheet" this has…
-
Plotting cost over time
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months. I am pretty sure each cost would need to be broken down into…
-
Missing columns on XML export of Gantt chart
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 missing. Really need this to work to tie into a portfolio management tool the company is…
-
Counting people with the same email domain in a multiselect assigned to cell
Hi there 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 the contacts in the cell belong to the same company. I.e. have the same email domain. In…
-
At Risk Formula Unparseable Error
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 duration minus % complete is 4 days. and the period of time between today and the end…
-
Different font in Gannt header exported to PDF
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?
-
count tasks per week number
Hi community, 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) : =COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project…