# EXCEL IF FUNCTION TO SMARSHEET

edited 03/04/21

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.

• ✭✭✭✭✭✭

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.khalil2009@gmail.com

• ✭✭✭✭✭✭

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.khalil2009@gmail.com

• ✭✭✭✭✭✭

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭

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

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭

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.khalil2009@gmail.com

• edited 03/04/21

Thank you for fast respond Bassam.

If document completed date is greater than the deadline than must return 'delayed', if not it should return 'on time'. But also if the document completed cell is empty, than formula should return an empty cell.

I hope I explained it well.

• ✭✭✭✭✭✭

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.khalil2009@gmail.com

• ✭✭✭✭✭✭

bassam.khalil2009@gmail.com

• @Bassam.M Khalil IT'S WORKING!

I don't know how to thank you enough for fast and helpful answers Bassam. 😊

Wish you all the best!

• ✭✭✭✭✭✭

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

bassam.khalil2009@gmail.com