Nov 09 2021 11:35 AM
I am trying to formulate a column that will return a DAYS formula result if multiple conditions are met, or a blank cell if they are not. Whatever I do, though, is returning a blank value.
The formula that I am using in Column K is
=IF(AND([@[Puchasing Agent]]="<>",[@GL]="0"),DAYS(TODAY(),[@[P.O. Release]]),"")
I should receive a numerical value if true, or a blank return if false. All I am getting is false values though. What am I doing wrong? Does it matter that the @GL column is a formula rather than a number? If so, I haven't had this issue when using similar calculations.
Nov 09 2021 11:38 AM
[GL] column contains numbers, not texts. Perhaps you mean "<>",[@GL]=0 (not "<>",[@GL]="0")
Nov 09 2021 11:41 AM
Nov 09 2021 11:48 AM
Nov 09 2021 11:54 AM
SolutionI miss nonblank checking. It'll be
=IF(AND([@[Puchasing Agent]] <>"",[@GL]=0),TODAY()-[@[P.O. Release]],"")
Nov 09 2021 11:57 AM - edited Nov 09 2021 12:12 PM
That worked perfectly. Thank you so much for your help!
Nov 09 2021 11:54 AM
SolutionI miss nonblank checking. It'll be
=IF(AND([@[Puchasing Agent]] <>"",[@GL]=0),TODAY()-[@[P.O. Release]],"")