A column did not accept the value
Each column type expects its own format: dates as YYYY-MM-DD, timelines as two dates, statuses and dropdowns as existing labels.
General Caster calculated a result, but the target column rejected it. The notification says which column, which value was produced and why. The formats each column type expects:
| Column | Expected value | Example formula |
|---|---|---|
| Numbers | A plain number with . for decimals |
ROUND({pulse.price} * 1.22, 2) |
| Date | YYYY-MM-DD, optionally with HH:MM:SS |
TEXT(TODAY() + 7, "YYYY-MM-DD") |
| Timeline | Two dates: start - end |
TEXT({pulse.start},"YYYY-MM-DD") & " - " & TEXT({pulse.end},"YYYY-MM-DD") |
| Status | An existing label | IF({pulse.numbers} > 10, "Done", "Working on it") |
| Dropdown, tags | Labels separated by , |
"Red, Blue" |
| People | Emails separated by ; (or , ) |
MONDAY.PEOPLE.EMAIL({pulse.person}) |
| Connect boards | Item IDs separated by , |
{pulse.connect_boards} |
An empty result usually means a column used by the formula is empty for that item. In the timeline example, the end date was missing, so the result was 2026-10-30 - .
Multiple values
Columns that hold several values give them to the formula, and take them back, with a separator suited to the data:
| Column | How several values look |
|---|---|
| Emails (mirrored email columns, people’s emails) | [email protected]; [email protected], ready for email integrations |
| Dropdown, tags, people, files, connect boards, mirror | Red, Blue · 1200, 300 |
| Timeline, week | 2026-11-01 - 2026-11-30 |
An email column gives the address alone. The MONDAY.* functions (for example MONDAY.NUMBER.SUM({pulse.mirror})) split the values the same way.
Working with lists
To count, filter, sort or join the values of these columns, see Lists and tables. To read the details of connected items and people (names, columns, emails, phones), see monday items, people and boards.
Recipes created before November 2026 keep joining multiple values with
+(Red+Blue,2026-11-01+2026-11-30), so their formulas keep working. To use the new separators, add the recipe again from the General Caster recipes. The formula debugger lets you choose either way.