Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2015, 07:14 AM
patrickd123 patrickd123 is offline Formula for filter "Incomplete Tasks for User..." Windows XP Formula for filter "Incomplete Tasks for User..." Office 2003
Novice
Formula for filter "Incomplete Tasks for User..."
 
Join Date: Dec 2011
Posts: 21
patrickd123 is on a distinguished road
Default Formula for filter "Incomplete Tasks for User..."

I need to built a custom filter similar to "Incomplete Tasks" that would additionally ask me for a specific user and show me only those of that user.



Problem is: the conditions inside the default "Incomplete Tasks" are two lines separated by a OR clause. Therefore, if I do the same adding a third line to request the username with a AND clause, logical precedence will likely give weird results since I want "(A OR B) AND C" and not "A OR B AND C". Since filter lines does not gives the option of parenthesis, I think I'm screwed.

Ideas?
Reply With Quote
  #2  
Old 04-07-2015, 08:15 AM
JulieS JulieS is offline Formula for filter "Incomplete Tasks for User..." Windows 7 64bit Formula for filter "Incomplete Tasks for User..." Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Unless you are working with Fixed Duration tasks, you should be able to use the % complete test only without having to worry about the OR condition.

You may also find the built in filter "Late/Overbudget tasks assigned to..." filter is more to your need. Testing solely whether the task is incomplete will show all future tasks that you wouldn't expect to be complete.
Attached Images
File Type: jpg patrick.jpg (62.7 KB, 4 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Option "Autolink inserted or moved tasks" fargo71 Project 1 03-08-2012 10:27 AM
Run *.bat once the outlook mail received with Subject line "welcome" on daily by user yogananda Outlook 0 03-04-2012 11:19 AM
Formula for filter "Incomplete Tasks for User..." How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
"MS Office has not been installed for current user" webyourstuff Office 1 07-28-2010 08:49 AM
Formula for filter "Incomplete Tasks for User..." Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft