Adding formula field to custom task form

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
 
S

Sue Mosher [MVP-Outlook]

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]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top