IF ISNOTBLANK Expression

[Scott_Hall]

Trying to get a the column [Current Status] to use a value of " " if the column [Destruction Signature] ISBLANK and use a value of “Destroyed” if [Destruction Signature] ISNOTBLANK

Was trying to combine an IF expression with ISNOTBLANK. This formula is however is not working. ISNOTBLANK(IF([Destruction Signature] =TRUE, “Destroyed”, “”))

Any advice on how to get an IF statement and ISNOTBLANK to play nice together?

Thank you in advance.

[Phil · Accepted solution]

Try:

IF (ISNOTBLANK([Destruction Signature]), “Destroyed”, " ")

[Scott_Hall]

Bingo. Thank you @Phil . I’d had a version of that at one point but didn’t have the () in the right places I guess.

[Aleksi]

IFS(ISNOTBLANK([Destruction Signature]),“Destroyed”) would work as well.