Please consider developing the ability to apply conditional formatting to top level (parent) rows. It looks weird when everything below the parent is in color, but the parent is grayed out. Thanks!
This discussion has been merged.
Hiya, Asking this question again as I have still seen no solution here. In a gantt chart is it possible to align the week number with a financial year? In our business our financial year starts the first week of July - This however comes up as week 27, not week 1. Cheers
Gantt charts cannot have cell linking when there is a predecessor assigned. My challenge is I need to have my sheet reference my vendor's sheets so that it automatically updates when they enter their date. This does not seem possible in all avenues I have ventured down. I tried using the Vlookup formula and I am unable to…
I want to add preparing for a quarterly meeting as one of the tasks in my list. The start date for the preparation is 3 weeks before the meeting and the end date is the date of the meeting. This repeats every quarter in the year for a total of 4 occurrences. How can I do this without having four different rows for each…
When a row is on the critical path, I'd like to be able to set conditional formatting so that it turns text red, or colours the cells, so that it is a more obvious visual cue that this task is a particularly important one.
For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…
Hi ! My Dashboards are meant to visualize high level information on my portfolio of projects. One key is visualizing the project duration on a Gantt Chart from Inception to Completion (Project Start to Project Finish Date), which shows as a single bar connecting the two dates. However, the Gantt Chart in the dashboard is…
I have team members with part time availability, as specified in their Resource Management profile. Smartsheet allows me to schedule tasks for the days they are not working - the sync to Resource Management then displays "100% allocated for 0 Days" - the 0 days is due to this being a non-workday for that team member.…
Hi! We have noticed that when Dependencies are on, filling an empty End Date cell (when the Start Date and Duration are also empty) with a date results in a cell value the day previous to the intended set date. Is this intentional, or is this a bug?