Find This Month


I'm trying to add a formula that will tell me if a date in a cell is this month. If a date is present in the reference cell, I get an INVALID OPERATION error. What am I missing?

=IF([Date Completed]@row = MONTH(TODAY()), 1)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!