I’ve been trying to figure out if I can create a formula around two date fields…
The situation:
Create a field with the possible outcomes as SOLD, PENDING, FIRM, CANCELLED depending on two date fields.
SOLD if Today is before Signing Date
PENDING if ...