Adding formula field to custom task form

  • Thread starter Thread starter SHC
  • Start date Start date
S

SHC

I'm trying to create a custom task form that includes a field for an
importance rank (1,2,3, etc) and a second field that calculates a
priority score based on the number of days until the due date
multiplied by the importance score: ([Due Date] - [Today's
Date])*[Importance Rank].

How do I do this? And how do I then publish the form so that it is my
default tasks form?

Thanks
SHC
 
Sounds like you've already figured out the formula, except that today's date is returned by the intrinsic Date() function.

Publishing is a matter of using Tools | Forms | Publish and setting the default form for your Tasks folder. See http://www.outlookcode.com/d/newdefaultform.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

in message news:[email protected]...
 
Back
Top