IF AND Function For Reporting
I am trying setting up a new report for my team which will allow them to bring through project activities based on the following criteria:
- The week the activity happened in is before today's current week.
- The RYG status is red OR green OR yellow
I am using a column set up as a checkbox and trying to put an IF( formula behind that to trigger a tick if the above criteria are present.
=IF(AND(WEEKNUMBER(Finish183) < WEEKNUMBER(TODAY())), 1)
This formula seems to work to tell me if the activity happened before the week I am in, however I am having difficulty adding the second criteria on to this.
Does anyone know how the formula should be formatted to ask the RYG status as a second criteria, but also only if it is red or green or yellow (don't want to report on blue)
Appreciate any help
Help Article Resources
Check out the Formula Handbook template!