Column values

What General Caster reads from each column type, and what a formula must produce to write into it.

Two simple rules

  • Columns with several values, like Dropdown or Connect boards, use + between values: first+second+third.
  • Columns with several parts, like Link or Location, use : between parts: first:second:third.

The format is the same in both directions: a column reference returns the value in this format, and a formula that writes into that column type must produce the same format. A Timeline reference returns 2013-02-08+2013-02-20, and to write a Timeline you produce the same kind of text.

All column types

ColumnValueExample
Checkbox true when checked, false otherwise true
Connect boards IDs of the connected items separated by + "69420+42069"
Country ISO 2-letter country code "IT"
Date ISO 8601 date, optionally with time in UTC
See Dates and times
 "2013-02-08" or "2013-02-08 17:30:00"
Email Address and displayed text separated by : "email@company.com:Company Inc."
File File names separated by + (read only)
Paid plan
 "document.doc+data.xls"
Hour Time in HH:MM format "17:30"
Item group Title of the group (read only)
Paid plan
 "Group Title"
Item name Name of the item
Paid plan
 "Item 1"
Jira Link to the Jira issue (read only)
Enterprise plan
 "https://monday.atlassian.net/browse/TBT-1"
Location Latitude, longitude and address separated by : "45.438611:12.326667:Venice"
Long text Plain text "Lorem ipsum dolor sit amet"
Mirror Mirrored values separated by + (read only)
Paid plan. See Subitems and mirrors
 "69420+42069"
Numbers A number 420
People id:type:name of each person or team, separated by +
Paid plan to write
 "69420:person:Tim Apple+42069:team:Management"
Phone Number and ISO 2-letter country code separated by : "42069420:US"
Rating A number from 1 to the scale of the column 5
Status The label
A missing label is created, see below
 "Done"
Tags Reads the tag IDs separated by +. To write, produce one tag name
A missing tag is created
 "urgent"
Text Plain text "Lorem ipsum dolor sit amet"
Time tracking Elapsed time in HH:MM:SS (read only)
Use HOUR, MINUTE, SECOND to split it
 "01:23:45"
Timeline Start and end dates separated by + "2013-02-08+2013-02-20"
Week First and last day of the week separated by + "2013-02-04+2013-02-10"
World clock IANA time zone "Europe/Rome"
Zendesk Ticket value (read only)
Enterprise plan

Status and Dropdown labels

When a formula produces a label that the Status or Dropdown column doesn't have yet, General Caster asks monday.com to create it. monday.com allows that only if the user who added the recipe can edit the column's labels, and a Status column has a limited number of labels: if the label can't be created, the value is rejected and you'll find the reason in the item updates and in the Console.

To avoid surprises, make the formula produce exactly the labels you already have, with the same spelling.

People

To assign someone, produce id:person or id:team, or the email of a user of the account; the name part is optional. Names alone are not accepted, because two people can share a name. The quickest way to find the ID is to read a People column that already contains the person: {item's Owner} returns 69420:person:Tim Apple.

IF({item's Status} = "Urgent", "69420:person", "42069:team")

To copy the emails of the people into a Text or Email column, use MONDAY.PEOPLE.EMAIL: it returns the emails separated by + and skips teams. It's available on every plan.

MONDAY.PEOPLE.EMAIL({item's Owner})

Empty values

An empty column returns an empty text, so check for it when the formula needs a value: IF({item's Date} = "", "DO-NOTHING", ...). To leave the target untouched, return DO-NOTHING: see Writing formulas.

Something unclear or missing? Tell us and we'll improve this page.