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 s...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendClarify? What if it's 29 days before or 91 days before? Your question talks about being equal to 30 days or 90 days.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Hi Mark,
I guess all I need is If field 2 is less than or equal to 30 days before today then mark as complete. you can forget about the 90 days one. Field 2 is a connected date field from another table not sure if that matters.
------------------------------- MarkShnier__You
The formula for a formula text field would be
IF([field 1]=1 and [field 2] <= Today() - Days(30), "Complete")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
