Calculating dynamic date formula

I am trying to work on a formula to show the latest month (ie last month). As we are receiving self-evaluation data at the end of the month, so now in January 2022, we should have received data for December 2021.

What formula should I use to always check the box for last month, especially when we are crossing over to the new year.

In the example above, We are in January 2022 now, it should check the box in row 1 in "Latest Month" column.

Initially I was using =IF(Mth@row = MONTH(TODAY()) - 1, 1)

But when crossing to the new year, this formula is "missing" something.

Can anyone help?

Vivien Chong

Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

Connect with us: 57network.com

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!