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?
Cheers, there is a fix in that latest update that allows you to filter formulas with ease.
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.
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.