Getting value of cell in another sheet based on multiple criteria using OR

I have a sheet (Data Updates) that is a log of updates to all of our databases, including future updates. The log includes the Product, the Updated Through Date, a Start Date [to start the update], an End Date [update should be completed by this date], and a Status (options: Next Up [this is the Updated Through date that is next to be updated], In Progress, Completed, and others that are not relevant to my question).

I also have a Data Updates Summary sheet with one Product per line showing details about the product, including the last update made (Status=Completed).

I want to see on the Data Updates Summary sheet the {Data Updates Updated Through Date} which meet these conditions: [Data Updates Summary Product]={Date Updates Product} AND ({Data Updates Status}="Next Up" or "In Progress").

I can use MIN(COLLECT)) to get the last one that was completed, but it's the "OR" part of my requirement that is problematic. How can I do this?


Karen Harker

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!