formula that checks if a project happened during the current month

Options

I'm trying to create a formula that checks if a project happened during the current month.

Example:

Project Start: 09/09/19 |  Project Finish: 12/13/19

Here is what I have that kind of works: =IF(AND(TODAY() >= Start@row, TODAY() <= Finish@row), 1, 0)

However, this formula does not work if the project happened during the current month, but the finish date is prior than the current day.

Example: Today's date is 11/19/19

Project Start: 11/01/19 | Project Finish: 11/12/19

This will not check the box.

So I need a formula that will check the box if at any point in the date range, it is the current month.

Any ideas?

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!