Formula help for graphs with data that "contains"....

How do I make a graph with data set from a list of dates that is greater than 12/31/21, less than 01/01/21, and then between )1/01/21-12/31/21, from a list such as this




I know the contains formula but this is to capture all dates prior to 2021, during 2021, and after 2021?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!