Skip to main content
Topics#Data ManagementQuestion de Brent Downey
Brent Downey (Pushpay) a posé une question dans #Data Management
7 janv. 2016, 20:01

Create a formula Status field based on a date field.

I'm trying to create a Status formula field on a custom object with three values:

 

Planned

 

Active

 

Completed

 

The values of this formula field will be driven by a date field called Showing

 

Here's what I have so far:

 

CASE(

 

IF(Date_of_Showing__c > TODAY(), "Planned", NULL),

 

IF(Date_of_Showing__c = TODAY(), "Active", NULL),

 

IF(Date_of_Showing__c < TODAY(), "Completed", NULL), NULL)

 

In this iteration, the formula is updating when the Showing date is in the past but no other values are displaying. I can't seem to figure out the correct operators for this to work. Some help would be appreciated.

 

Thanks!

 

Brent
8 réponses
  1. Mayank Srivastava (eVerge Group)
    7 janv. 2016, 20:04

    Brent, you don't need the CASE function. All you need is this:

    IF(
       Date_of_Showing__c > TODAY(), "Planned", 
       IF (   
              Date_of_Showing__c = TODAY(), "Active", 
              "Completed"
         )
    )

     

     
Rédiger une réponse...
0/9000