How can I modify the formula below to also count "Yellow" in addition to the "red"

Joan B

=COUNTIFS({DM Facility Specific Status Updates Start Date}, TODAY(), {DM Facility Specific Status Updates Supply Red}, "red")

Ryan Sides

Hi Joan, use the OR function for the “red” and “yellow”

=COUNTIFS({DM Facility Specific Status Updates Start Date}, TODAY(), {DM Facility Specific Status Updates Supply Red}, or(@cell = “red”, @cell = “yellow))

https://community.smartsheet.com/discussion/34181/countifs-using-and-as-well-as-or