# If Blank Statement

783 3
cancel
Showing results for
Did you mean:
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
16 - Uranus
``````IF(
{Remaining Term (YRS) (as of today)},
{Remaining Term (YRS) (as of today)} & " years, " & Months,
"Vacant"
)
``````
18 - Pluto

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"
)
``````
4 - Data Explorer

Thank you!! These both worked perfectly.