Smartsheet formula for dynamic MM-YYYY display

Amark

Hi everyone,

I’m trying to build formulas in Smartsheet to automatically generate three rows showing:

• Month-Year (MM-YYYY)
• Month (MM)
• Year (YYYY)

For example, I want the output to look like this based on the current month:

• Month-Year: 1-2026, 2-2026, 3-2026
• Month: 1, 2, 3
• Year: 2026, 2026, 2026

These should dynamically update based on the current date (e.g., current month, previous month, and month before previous).

What formulas can I use to achieve this across columns?

Thanks in advance!

Paul Newcome

Current:

=MONTH(TODAY()) + "-" + YEAR(TODAY())

=MONTH(TODAY())

=YEAR(TODAY())

Previous:

=MONTH(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1), DATE(YEAR(TODAY()) - 1, 12, 1))) + "-" + YEAR(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1), DATE(YEAR(TODAY()) - 1, 12, 1)))

=MONTH(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1), DATE(YEAR(TODAY()) - 1, 12, 1)))

=YEAR(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1), DATE(YEAR(TODAY()) - 1, 12, 1)))

Next:

=MONTH(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1), DATE(YEAR(TODAY()) + 1, 1, 1))) + "-" + YEAR(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1), DATE(YEAR(TODAY()) + 1, 1, 1)))

=MONTH(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1), DATE(YEAR(TODAY()) + 1, 1, 1)))

=YEAR(IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1), DATE(YEAR(TODAY()) + 1, 1, 1)))