đź“… Calendar-based month picking in your formulas
We’ve improved how to work with month-based modifiers in your formulas!
Before, autocomplete could be confusing. When typing statements like IF CurrentMonth IS Jan or Variable.Jan25, the suggestions weren't always helpful. You might have seen a vague "MONTH" suggestion or a few specific months, but it was hard to know what to type or see all available options.
✨ What’s new?
Now, selecting months is intuitive and visual. Instead of guessing, you can choose months from a new calendar selector within autocomplete. This makes building formulas faster and clearer.
You can easily pick:
- Recurring [month] (e.g., Jan for any January).
- Specific [month] [year] (e.g., Jan25 for January 2025).
⚙️ How does it work?
When typing a formula that requires a month modifier (e.g., after IF CurrentMonth IS, or as a property like Variable.), the autocomplete suggestions will now display the Recurring [month] / Specific [month] [year] options.
- For recurring months: Select the month name (e.g., Jan). from the calendar This inserts the modifier for that month in any year (e.g.,
IF CurrentMonth IS Jan). - For specific months: Select the month name and the desired year from the calendar (e.g., Jan 2026). This inserts the specific modifier (e.g.,
Variable.Jan26orIF CurrentMonth IS Jan26).