Skip to main content
Topics#Data ManagementBrent Downey의 질문
Brent Downey (Pushpay) 님이 #Data Management에 질문했습니다
2016년 1월 7일 오후 8: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개
  1. Mayank Srivastava (eVerge Group)
    2016년 1월 7일 오후 8: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"
         )
    )

     

     
답변을 작성하세요...
0/9000