EXCEL IF FUNCTION TO SMARSHEET

Irina Surladžioska
edited 03/04/21 in Smartsheet Basics

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 😀

Best Answers

Answers