Forum Discussion

Kate_McCulloch's avatar
Kate_McCulloch
Regular Visitor
1 year ago
Solved

Equal to or less than calculated Column

Looking to calculate is a date is less than or equal too calculated column which I have partly working, however if the date is blank its treating that as equal too or less than. How can I build in if the column is blank, this is my formula at the moment, I hvae tried adding a third calculation to say if its is blank but still returning 'Yes' 

 

if(FMRTS [Episode Start Date]<= FMRTS[Form Start Date],"Yes",if(FMRTS[Episode Start Date]>= FMRTS[Form Start Date],"No","No"))
Need Help
  • techies's avatar
    techies
    1 year ago

    Hi Kate_McCulloch please check this

     

    Episode Check =
    IF (
        ISBLANK(FMRTS[Episode Start Date]),
        "No",
        IF (
            FMRTS[Episode Start Date] <= FMRTS[Form Start Date],
            "Yes",
            "No"
        )
    )

4 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    1 year ago

    I think you can use

    IF (
    FMRTS[Episode Start Date] <= FMRTS[Form Start Date]
        && NOT ISBLANK ( FMRTS[Form Start Date] ),
    "Yes",
    "No"
)
  • techies's avatar
    techies
    Icon for Super User rankSuper User
    1 year ago

    Hi Kate_McCulloch please check this

     

    Episode Check =
    IF (
        ISBLANK(FMRTS[Episode Start Date]),
        "No",
        IF (
            FMRTS[Episode Start Date] <= FMRTS[Form Start Date],
            "Yes",
            "No"
        )
    )