This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
Kamille_Parks:
IF(
{Remaining Term (YRS) (as of today)},
{Remaining Term (YRS) (as of today)} & " years, " & Months,
"Vacant"
)
Thank you!! These both worked perfectly.
