none
Custom Field formula that references Flag name RRS feed

  • Question

  • I'm trying to clean up a formula for a Custom Flag Field.

    Right now, the formula for FlagX is: "seek_name"=[Resource Names], and the title of the Flag is "seek_name"

    What I'd like to do is have the formula be: [Flag1 name]= [Resource Names], so that if the name of the Flag is updated, the formula doesn't need updating.

    Is this possible? I see how to pass in the boolean value of the Flag itself, but not its custom title.

    Friday, November 3, 2017 4:04 PM

All replies

  • mean_liar,

    I'm a little lost as to what your filter is doing. Did you rename the Flag X field as "seek_name"? So what is the actual custom field formula (e.g Flag1=??)?

    If you are attempting to use a filter to test for a custom field name, sorry but you need VBA for that.

    Regardless of how you rename a field, Project will always recognize the actual field designation. For example, you can rename the Text1 field as "Count" and it will show in the field list as "Count (Text1)" but you can always refer to it simply as Text1 in any formula.

    Hope this helps.

    John

    Friday, November 3, 2017 4:30 PM