case

Syndicate content
How to Add Time Zones to Your Sales and CRM Application

Note: The advice in this article addresses how to accomplish this for states that have only one time zone. It won't work for states with multiple time zones.

Have you ever called a customer at 9:00 AM on the East coast only to find that your customer is on the West coast and its 6:00 AM and you just woke them? This happens all the time.

December 13th, 2009 - 12:12 PM

Here is an example of a formula that returns a different price for each of several kinds of fruit. The data type of the result is Number.

case ([Fruit Name], "Apples", .5, "Pears", 1, "Berries", 4)

If the [Fruit Name] doesn't match any of the cases, null is returned. To return a default value when there is no match, add one more Number argument to the end.

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit