I keep trying to google, search and i am not landing on what i need. My coding understanding, as minimal as it is, is only enough to get me into trouble.
As a general expression of what i wish to achieve; i want to make a view, that shows items::
- are over 28 days or more beyond creation
- without being completed.
- that don’t have a specific due date that has passed (If it has passed due date then report as normal from created date).
I need a formula that:
Looks at the field “Created Date” field and compares to todays date.
Looks at the Field “Work Completed” (If checked or not) returning “nil”? if it is complete.
Looks at the field “Due Date” field and if (“today”) is not past that date, returns “nil”.
Outputs “4 weeks+” for any period 28-55 days
Outputs “8 weeks+” for any period 56-83 days
Outputs "12 weeks+ for any period 84 days
Thanks in advance!