Hello,
I have 2 fields, field 1 is a number field and field 2 is a date field from a relationship.
I would like a formula that says if field 1 =1 and it's 30 days before the date in field 2 then say complete.
but if field 1 =1 and it's 90 days before the date in field 2 then say schedule.
How would I write that in a formula?
------------------------------
