Can someone help me with this formula?

Options
Anna_G_F_P
edited 07/26/22 in Formulas and Functions

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"))

Best Answer

  • Alex.Dixon
    Alex.Dixon ✭✭
    Answer ✓
    Options

    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

Answers

  • Alex.Dixon
    Alex.Dixon ✭✭
    Answer ✓
    Options

    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
    Options

    Awesome. Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!