Microsoft Project 2013 Tutorial | Using Formulas In Custom Fields

Want all of our free Project 2013 videos? Download our free iPad app at itunes.apple.co...
More details on this MS Project 2013 training can be seen at www.infiniteski... This clip is one example from the complete course. For more free tutorials please visit our main site. KZbin: / oreillymedia
Facebook: www.facebook.c...
Twitter: / oreillymedia
Website: www.oreilly.com/

[@kooroshhaziny8992]

Thank you so much for the video, I really appreciate that.

[@janezbond4136]

How did u get Michael Caine to do voice over =). Anyway, loved the video =).

[@Faiselmoha]

Is there a way to separate labour, equipment and material costs in a column?

[@matthewsinnen4987]

Great video. Hoping you can help me with a more advanced custom field. A coworker is setting up an MS Project...project, and she asked for some help adding a custom field that would convert the Start date field into our Fiscal Quarter Fiscal Week schema, to display as FQFW, e.g. Q1W1. I've written the formula in excel, but I've never even touched Project until this week. Apparently it doesn't take formulas quite the same way as Excel does. I tried using the ''Switch" function in Project, and it worked, but it only accepts 14 arguments, and there are obviously 52 weeks we're dealing with. Do you have any suggestions? Would there be a way to do this using VBA? (I know next to nothing here as well.) Formula where H10 is the Start Date: =IF(AND(H10>=DATE(2014,2,1),H10=DATE(2014,5,3),H10=DATE(2014,8,2),H10=DATE(2014,11,1),H10

[@janboomstam8585]

Hello O' Reilly my problem is that I have a formula for duration, but the problem is that you have duration and duration 1 my answers appear on the duration 1 but I can't find out how to, make the outcome of duration 1 appear directly on my gantt chart It's such an annoying problem cause it's the last step, could you please help me?

[@d12kiem7]

Liverpool accent?