Skip to main content

Hello- I am a formula novice. I have created a countdown formula to track how many years and months I have before my leases expire. If looks as follows:

({Remaining Term (YRS) (as of today)}& " years, "& Months)


This formula works well, but I cant seem to add a “IF” statement. that if my {Remaining Term (YRS) (as of today" field is blank, i.e., no date, that the formula returns the result “Vacant”


Any help would be appreciated.

IF(

   {Remaining Term (YRS) (as of today)},

   {Remaining Term (YRS) (as of today)} & " years, " & Months,

   "Vacant"

)

If the fields {Remaining Term (YRS) (as of today)} and {Months} are numbers, Kamille’s formula will say “Vacant” when there are 0 years, but still some months.


Here is an alternative formula.


IF(

  OR(

    {Remaining Term (YRS) (as of today)} & "",

    {Months} & ""

  ),

  {Remaining Term (YRS) (as of today)} & " year(s), " & Months & " month(s)",

  "Vacant"

)

Thank you!! These both worked perfectly.

Reply


Terms & Conditions