EXCEL IF FUNCTION TO SMARSHEET

Question

Hi, I've tried everything and I still can't make a formula work in Smartsheet. Formula in EXCEL: =IF(K269>0;IF(K269>J269;"DELAYED";"ON TIME");"") Formula in SMARTSHEET: =IF([Doc completed]@row > 0, IF([Doc completed]@row > [Deadline for doc]@row, "DELAYED", "ON TIME"), " ") So if document completed date is not empty, than use IF([Doc completed]@row > [Deadline for doc]@row, "DELAYED", "ON TIME"), but if it's empty don't return any value. I've tried to change first logical expresion with <> 0 (not exual to 0) and <> " " (not blank) but I just can't make it work. Please help me, cuz I'm beginning to have a mental breakdown 😀

Bassam Khalil · Accepted Answer

Hi @Irina Surladžioska

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Bassam Khalil · Accepted Answer

@Irina Surladžioska

please try the following formula:

Status =IF(ISBLANK([Doc completed]@row), "", IF([Doc completed]@row > [Deadline for doc]@row, "Delayed", "On Time"))

the following screenshot show the result on my sample sheet

Bassam Khalil · Accepted Answer

@Irina Surladžioska

Happy to help you anytime

Bassam Khalil · Accepted Answer

@Irina Surladžioska

You are welcome and am happy it's worked, you can Vote for me 😀😂😉