Filter events by date column based on the week.

Options

I have an annual events spreadsheet where one of the columns is a drop-down menu with all the dates of the year, where we select all the dates of the event, which usually lasts more than 1 day. I need to filter the events that are happening in the week, that is, the events that will have data in this column in the next 7 days. Does anyone know how I can do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!