Help

If Blank Statement

619 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Kim_Cassett
4 - Data Explorer
4 - Data Explorer

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.

3 Replies 3
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"
)
Kim_Cassett
4 - Data Explorer
4 - Data Explorer

Thank you!! These both worked perfectly.