No announcements
Found 2424628 threads
-
0 VotesProject Custom Fields Formulae - Online Resources
Be advised that there are some vba-derived functions that do work in custom field formulas, but many do not.Answered | 9 Replies | 1181 Views | Created by rapscalli - Tuesday, March 1, 2016 3:56 PM | Last reply by Ismet Kocaman - Friday, March 4, 2016 1:40 PM
-
3 Votes
Calculated field formula results in syntax error when using Dutch(Belgium)
Hi Brecht, I also always use Dutch(Belgium).Answered | 1 Replies | 5343 Views | Created by Brecht DB - Wednesday, April 10, 2013 7:38 AM | Last reply by endeka - Wednesday, April 10, 2013 8:45 AM -
0 Votes
How do I do this??
Hi vicky calver, Based on your description, I test you issue in my own environment with IF and VLOOKUP formula.Answered | 3 Replies | 944 Views | Created by vicky calver - Friday, May 22, 2015 2:56 PM | Last reply by George123345 - Monday, May 25, 2015 5:59 AM -
0 Votes
Created a formula in Master schedule but not calculating in sub projects
Hotmail1, Sorry but assignment rows do not accept formulas.Answered | 2 Replies | 9312 Views | Created by Hotmail1 - Friday, January 28, 2011 4:47 AM | Last reply by John - Project - Friday, January 28, 2011 3:57 PM -
0 Votes
Is it possible to use Deliverable GUID in a MS Project Formula?
The following macro will do that: Sub CopyDelGUID() Dim t As Task For Each t In ActiveProject.Tasks ...Answered | 3 Replies | 1753 Views | Created by Chris Sobolewski - Friday, January 31, 2014 6:02 PM | Last reply by John - Project - Monday, February 3, 2014 4:22 PM -
1 Votes
Handling Excel formula errors in PQ
Replace Error simply doesn't do anything and, when I use Keep Errors, it returns an empty list.Answered | 3 Replies | 655 Views | Created by vituutiv - Thursday, November 10, 2016 5:46 PM | Last reply by Imke Feldmann - Friday, November 11, 2016 1:38 PM -
0 Votes
Formula to identify Anomalous Durations
I find the "help" on custom fields a bit obscure, classic Microsoft it assumes you know more than you do when providing answers to questions.Answered | 5 Replies | 4333 Views | Created by Dominic Moss - Friday, October 26, 2012 10:43 AM | Last reply by Dale Howard [MVP] - Thursday, November 29, 2012 1:33 PM -
0 Votes
Not able to use formula on enterprise Project type field( PWA Project 2016)
I am with you and understand that Customers will DO an Republish "over Night".Answered | 14 Replies | 2404 Views | Created by DJINDAL2001 - Wednesday, May 30, 2018 1:33 PM | Last reply by Stefan Schwarz DE - Tuesday, July 3, 2018 8:28 AM -
0 Votes
Formula Error while Executing as expression.
And “\” is used to divide two numbers and returns an integer result.Answered | 3 Replies | 893 Views | Created by Mo Yusuf - Wednesday, April 1, 2015 2:00 PM | Last reply by BI_Support - Thursday, April 2, 2015 4:50 AM -
3 Votes
Conditional Formatting: content is a value or the result of a formula
, then select Use a formula to determine which cells to format.Answered | 4 Replies | 1803 Views | Created by Noah Vlaminck - Saturday, September 14, 2013 5:58 PM | Last reply by Noah Vlaminck - Sunday, September 15, 2013 3:44 PM -
0 Votes
How do I level projects that are checked-out?
So if I want to level mulitple projects simultaneously I have to check each of them out, is that correct?Answered | 3 Replies | 8916 Views | Created by Kimberly2011 - Thursday, March 24, 2011 3:09 PM | Last reply by Ben Howard [MVP] - Thursday, March 24, 2011 5:17 PM -
0 Votes
How do you change this formula into VBA
=Sheets("Cilvēku saraksts").Range("E2") Then result = "Steidzami ziņot" Else result = "Viss kārtībā" End ...Answered | 2 Replies | 367 Views | Created by PapsLv - Thursday, September 15, 2016 7:44 PM | Last reply by Winnie Liang - Tuesday, September 27, 2016 6:41 AM -
2 Votes
Using Conditions in InfoPath - How do I avoid getting NaN
I have been trying to follow the steps as closely as I can, but am still getting a NaN error in the field when trying to submit.Answered | 13 Replies | 24689 Views | Created by efebo - Wednesday, May 20, 2009 3:41 PM | Last reply by RJM1974 - Tuesday, May 28, 2013 12:37 PM -
6 Votes
Dax formula and Pivot Table result
Does this formula do what you are looking for?Answered | 10 Replies | 1127 Views | Created by joseluis88 - Friday, June 24, 2016 10:45 AM | Last reply by Dan P Y - Tuesday, July 5, 2016 5:45 AM -
3 Votes
Formula for % Baseline
But what i meant is instead of the Project Managers updating the % on their own in their own Microsoft Project, the PMO will be updating and provide them later with ...Answered | 15 Replies | 15202 Views | Created by Shazlee69 - Friday, November 11, 2011 6:00 AM | Last reply by Jan De Messemaeker - Project MVP - Friday, November 18, 2011 8:25 AM -
0 Votes
How to avoid this Mdx error
But 9 is the Sku not present now so it is showing a #value error in the browser.Answered | 2 Replies | 4174 Views | Created by Tanmoy Santra - Thursday, January 28, 2010 10:55 AM | Last reply by Raymond-Lee - Monday, February 1, 2010 2:59 AM -
0 Votes
Problem with convert an Excel formula to a PowerPivot formula
This will keep your DAX simpler and avoid data type issues elsewhere.Answered | 1 Replies | 4266 Views | Created by XeonCore - Thursday, November 22, 2012 12:12 PM | Last reply by Brent Greenwood - Thursday, November 22, 2012 2:30 PM -
0 Votes
Read Project Owner field using formula
Yes Maaz, but I was looking for a method to read it using regular project server formula expression.Answered | 7 Replies | 5998 Views | Created by _cODE_fOR_fUN - Sunday, January 8, 2012 11:04 PM | Last reply by Maaz Ibrahim - Tuesday, January 10, 2012 11:27 AM -
0 Votes
Formulas causes high memory in excel
Excel takes time to calculate all the formula and show us results.Answered | 3 Replies | 1439 Views | Created by May8692 - Wednesday, December 9, 2015 3:16 AM | Last reply by Melon Chen - Tuesday, January 12, 2016 8:58 AM -
0 Votes
Why do I have to redeploy my Report files to avoid errors?
Doing a sort by date, I can see that the times coincide with when I deployed the projects.Answered | 23 Replies | 1084 Views | Created by hatessunlight - Thursday, August 20, 2015 3:51 PM | Last reply by hatessunlight - Friday, August 21, 2015 8:31 PM
No announcements
