Adding an ISBLANK


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!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!