-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
-
Gantt charts and Dashboards
Hi. new here to the forum; recently created a Smartsheet Gantt chart and subsequently integrated it into a Smartsheet Dashboard. Looks great except --- I seem to have lost my indentation of my subtasks under a parent task, and that makes reading the results a lot more difficult. The other thing that I'd love to do is to be…
-
Show dealy in gantt chart
Hi We are trying to use Gantt chart, for planning a project timeline. We have expected start, actual start, planned end date and actual end date, because sometimes something gets in the way and we can't hold the original timeline. But we want to know how much of a delay we have or doesn't have. So we use the dates to…
-
Is there a way to Edit when a Quarter (Q1, Q2, Q3...) starts in SmartSheet GANTT Tool?
As of right now, I can sort my GANTT charts including QUARTER data on the header. (Q1, Q2, etc.) But it always assumes that the first Quarter starts in Jan: My company's Fiscal Year starts in Oct. So, my Q1 is OCT-NOV-DEC. Anyone knows if there's a way to tell Smartsheet to use my configuration for Quarters instead of the…
-
fixed durration vs. fixed start/end dates (deadlines) with gantt chart
I'm trying to develop a template for scheduling the 30 to 60 sub tasks in each of the many year long projects I'm managing. Im hoping to use a dashboard to tack all the projects at once. but for the template id like to set up an easily adjusted Gantt calendar. There are dates that are subject to fixed dates like quarterly…
-
Printing filtered Gantt chart
I've got a large construction programme on a gantt chart and I am able to filter it to individual contractors (using 'assigned to' column). But I can't find a way to print out the filtered programme to just show each contractor their tasks to assist them with resourcing. Is there any way to do this ? Thanks in advance for…
-
Scheduling 30-60 task annual projects with just 200 whole working days per year
I want to develop a template sheet that I can use to easily schedule out 30 to 60 different 30 min subtasks evenly over 200 specific available work days each year. I started out trying to set up a gantt view row with "200d" working day duration then removing sat/sun, and inputting 62 other Non-working days in gantt view…
-
Cross Project Dependencies
Hi SmartSheet Community! I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete. Example, I'm making ice cream and I have three projects in the portfolio: Vanilla…
-
Change Milestone Diamond Color
Hi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀
-
Mutliple dates displayed as milestones in a Gannt report
Hi I have a portfolio sheet of project titles in rows that lists their Stage Gate dates (SG1-6) in columns. I want to create a report that shows those dates as milestones in a Gannt - each row (project) would essentially display 6 milestones. Is there any way to do that?