Less than/Equal IF statement



1 comment

  • Official comment
    Alan Mark

    Hi Brendan,

    Sorry for the late response, it seems there was a Zendesk email notification outage the day you posted this!

    I tested and was able to get the desired result with syntax like in your first example:

    IF(ISBLANK(#Sheet!datecolumn);'NA';IF(BEFORE(#Sheet!datecolumn;ASDATE('2019-01-01 00:00:00'));'Before';'After'))

    Please let us know if you have any further questions.


    Comment actions Permalink

Please sign in to leave a comment.