You need to sign in to do that
Don't have an account?
MichaelWould
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
IF(AND(datefield>TODAY(),logical2),"TRUE", null)
forcedotcom
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.