Hi there,
I have this formula
(Rate__c *  Number_of_Hours__c) + (Rate__c /(60/ Number_of_Minutes__c ))
to calculate total sum to be paid based on hours and minutes worked.
The problem is, the if the minute field is left blank, I receive an #Error#. If I leave the hour field blank - it's fine, so I've been compensating by making 1 hour into 60 minutes, and it's doing nicely, but it's not ideal!
anyone have any suggestions?
thanks!
Hudi

Hello,

Does anyone know how I can create a search or report that will show me what new opportunities have been added over the last 7 days?

This would be something I would access frequently so when ever I check it, it would pull the last 7 days worth of data.

Thanks!

Message Edited by Hullinator on 10-27-200710:25 PM

Im looking for a formula that is based on date.  So basically, a customer calls and in the contact record I want a field that indicats if the customer is "in service" or "out of service".  When a customer buys our product they get 1 year of free service.  So,  365 days later they are "out of service".   I want a field in the contact record to be based on this date.  In theory this date would be pulled from the latest "transaction date" in the "retail transactions" section.  Is this even possible?

Thanks, Mac

Based on a pick list in a case reason --Require two other fields. I need to have two other field required when the list box option Late to promise is selected in a custom field. Please supply a validation rule if possible. I cannot require on the page layout as other ooptions do not require this field Thank You

Message Edited by SFDC Keeper on 10-21-2007 08:11 PM

hello,

I have a text field and i want to allow users to enter only a-z letters, no special characters such as &, $.... and no space between letters

thx for you help