Sign in to join the conversation:
If I did not start with a template that includes start, end date and duration, is there a way to add those so that end date automatically calculates from the start date plus duration?
You'll need to add a start and finish column that are set as dates, then right click on the header of a column and choose edit project settings to enable dependencies and duration.
Or you could add the appropriate columns as listed above and enter
=[Start Date]@row + Duration@row
This will automate the End Date without having dependencies enabled.
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
When I print my dashboard, the color coding next to the divisions disappear. Any clue to a fix?
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
