Jul 21, 2021 11:59 AM
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.
Jul 21, 2021 12:02 PM
IF(
{Remaining Term (YRS) (as of today)},
{Remaining Term (YRS) (as of today)} & " years, " & Months,
"Vacant"
)
Jul 21, 2021 01:26 PM
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"
)
Jul 21, 2021 01:40 PM
Thank you!! These both worked perfectly.