(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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?
Printer-friendly version
Send to friend
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.
Email: PPadmin@planningplanet.com
Replies