Skip to content
ProjectControls.com
Asta Powerproject

Filtering Formula Columns

In the Open Standard
Craig McCartneyMember for 11 years 1 month
Created
3
3
0

Hi Guys,

I have created a formula column called ductwork, which simply outputs a 1 if the task name contains the word ductwork and 0 if not. My formula works great, however I would now like to create a filter to hide all 0's in a column, I have tried the filter tab, but it appears it wont let me filter the column. Can anyone offer some advice regarding how I can over come this?

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi CraigTwo options.You can

    Hi Craig

    Two options.

    You can copy paste the results of your formula into a user field and filter on that.

    Just filiter on *Ductwork* in the Names and Titles filter section.

    Best regards

    Mike T.

    Report
  2. 0
    Robert Hughes ·
    #2

    Hi Craig,Didi you have any

    Hi Craig,

    Didi you have any particular reason for going about it this way?

    As Mike says, you can setup a filter to searh activity titles using the 'Bar/Task title' filter condition which will acheive the same result.

    Report
  3. 0
    Craig McCartney ·
    #3

    Cheers, there is a fix in

    Cheers, there is a fix in that latest update that allows you to filter formulas with ease.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?