Adding an ISBLANK

SKP · 03/24/22

Hi there,

I have my formula that works but forgot I needed to add a clause for when a column cell is empty so it doesn't return an error, which I'm hoping will allow me to make it a column formula without too much fuss.

I'm trying to use ISBLANK as that seems like the best option and I just can't see the problem but it keeps saying it's unparseable. The bracket colours match up, which is leaving me a bit stumped! Can anyone see what is wrong, please?

=IF(OR([End Date]@row > TODAY(), Status@row = "Complete"), "",

IF((AND([End Date]@row < TODAY(), [X Formula]@row > 5)), [Y Formula]@row),

IF(ISBLANK([End Date]@row), "Blank"))

Thank you so much!

Andrée Starå · 03/24/22

Hi @SKP

I hope you're well and safe!

Try something like this.

=
IF([End Date]@row="","",IF(OR([End Date]@row > TODAY(), Status@row = "Complete"), "",
IF((AND([End Date]@row < TODAY(), [X Formula]@row > 5)), [Y Formula]@row)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 03/24/22

@SKP

Happy to help!

Easy to miss!

Andrée Starå · 03/24/22