HunterB

2 years agoQrew Cadet

# Help with Creating Formula

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?

------------------------------