+ Start a Discussion
MichaelWouldMichaelWould 

Help with combining 2 formulas. 1 text field and 1 date field to return a text value.

Hi,

 

I need the one formula to return the text value of TRUE if two conditions are met.  The date cannot be greater than today and the text must have a specific name, otherwise the return value is to be blank.

 

IF( datefield > TODAY(),
"TRUE",
null ) 

 

and If a text field has "something" then I need the text value of TRUE returned.  Both conditions need to be met otherwise the return value to be blank.

 

Thanks in advance...

 

Michael

 

 

 

forcedotcomforcedotcom

IF(AND(datefield>TODAY(),logical2),"TRUE", null)

 

forcedotcom

MichaelWouldMichaelWould

Thanks for the reply.  The logical2 needs to check a specific name rather than just any text - how would this be done?

 

Thanks in advance.

forcedotcomforcedotcom
IF(AND(datefield>TODAY(),Your_Field__c = "textstring"),"TRUE", null)
MichaelWouldMichaelWould
Thank you very much, it works as I wanted it to.:smileyhappy: