Hi there! super new to airtable and learning my way around…here is what i am trying to accomplish:
i run a property management company and i have created a construction and vacancy Base for each property manager. it is their responsibility to keep it up to date.
ideally, i would love if i could turn certain cells RED or ORANGE to alert the property manager. For instance:
we have a column “Listed Rent”, and lets say it’s $1,000/month.
we have another column "date marketed"
what would be great is if we could turn the $1,000 cell red IF the date in the date marketed field is over a certain time.
that make sense? what that would do is alert me that maybe we should drop the price if it is not being rented at 1,000 for over a few weeks