Adding an IF(ISBLANK() function

Ashlyn

Currently I have the formula: =IF([No Days to Close OSR]@row <= 60, "Yes", "No")

I am wanting to add a function where, if the cell in the column "No Days to Close OSR" is blank that it assigns a "TBD".

I have tried writing it as: =IF([No Days to Close OSR]@row <= 60, "Yes", "No"), IF(ISBLANK([No Days to Close OSR]@row = Blank, "TBD")

Could someone help me correct this formula? Thank You!

Paul Newcome

Try this instead:

=IF([No Days to Close OSR]@row = "", "TBD", IF([No Days to Close OSR]@row <= 60, "Yes", "No"))

Paul Newcome

Try this instead:

=IF([No Days to Close OSR]@row = "", "TBD", IF([No Days to Close OSR]@row <= 60, "Yes", "No"))

Ashlyn

This worked!

Thank you so much for taking the time to answer my question!

Paul Newcome

Happy to help. 👍️