Can someone help me with this formula?

Anna_G_F_P

I'm trying to get True False values if Document Number is blank and DL Status=Ready for Review

=IF(AND(ISBLANK([Document Number]@row), ([DL Status]@row)="Ready for Review", "True", "False"))

Alex.Dixon

Assuming that you directly copy-pasted your formula, I believe it to be a simple misplaced parenthesis. Currently your [, "True", "False"] is inside the AND function. To resolve, remove your last parenthesis and add one before the comma before "True".

=IF(AND(ISBLANK([Document Number]@row), ([DL Status]@row)="Ready for Review" ) , "True", "False" ) )

-Alex

Alex.Dixon

Assuming that you directly copy-pasted your formula, I believe it to be a simple misplaced parenthesis. Currently your [, "True", "False"] is inside the AND function. To resolve, remove your last parenthesis and add one before the comma before "True".

=IF(AND(ISBLANK([Document Number]@row), ([DL Status]@row)="Ready for Review" ) , "True", "False" ) )

-Alex

Anna_G_F_P

Awesome. Thank you!