EXCEL IF FUNCTION TO SMARSHEET

Irina Surladžioska · 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.

Please help me, cuz I'm beginning to have a mental breakdown 😀

Bassam Khalil · 03/04/21

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 · 03/04/21

@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 · 03/04/21

@Irina Surladžioska

Happy to help you anytime

Bassam Khalil · 03/04/21

@Irina Surladžioska

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

Bassam Khalil · 03/04/21

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.

Irina Surladžioska · 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.

Thank you in advance.