https://www.msofficeforums.com/project/ The Project section of MSOfficeForums has a small but thriving community.

I entered your formula into Text1 custom field and was able to use it in Bar Style.

I’m using Microsoft 2010

Can you replicate the table in Excel using dummy tasks and share a screenshot, so that we can get an idea of what you have in mind

Add a WBS column to your View.

Then add a Custom Field, say Text1 and add this formula to it and also use formula for Summary Rows.

IIf(InStr([WBS],”.”)=0,0,Left([WBS],InStr([WBS],”.”)-1))

This formula extracts the part of the WBS before the first decimal point.

Therefore assuming you want to show all tasks and summary rows under WBS 2, your…[Read more]

Lags use successor task calendar, so in your case the calendar of the “Event on 30th” will determine the duration of your lag.

If this event uses a Standard calendar, then your lag will be 15 days and if it is on a 7-day calendar, your lag will be 21 days.

I’d assign “As Late As Possible” constraint to the tasks, Generate Documents, Submit…[Read more]

I’d like to think this a Bar formatting issue and most likely a flag has been used to define Summary Task bar and this flag has been applied to some summary tasks and not others.

If you use the default “Task Range” & “Date Range” filters that come with Microsoft Project, you will always be prompted to enter range values, since these are dynamic filters.

Create custom Task Range or Date Range filters and they will be saved with your View. An example of a custom task range filter shown below.…[Read more]

To save your filter with a view, go to the View tab and click on Gantt Chart dropdown menu in the Task Views group.

Then click on More Views and in the More Views dialog, click on Copy button.

This will open the View Definition dialog. You can now give the name “Filtered View” and in the Filter dropdown, select your special Filter. Remember to…[Read more]