Supported columns

COMPATIBLE COLUMNS

Check, Country, Creation Log, Date, Dropdown, Email, Formula, Hour, Item ID, Last Updated, Link to Item, Long Text, Numbers, Person, Phone, Rating, Status, Text, Timeline, Time Tracking, Vote, World Clock

Subitem Names and the Count of Subitems are also supported.

Column Values Fetched and Projected by Formula PRO.

Column

FORMULA

What is fetched

Formula expression result

Example

SUM(2,3) => 5

Column

PEOPLE

What is fetched

ID:type:name separated by plus

Example

"22590:person:Jack Reacher+33484:team:tech"

Column

STATUS

What is fetched

Status index:Status label separated by plus

Example

1:Done+2:Stuck

Column

DATE

What is fetched

ISO 8601 date/time

Example

"2013-02-08" or "2013-02-08 17:30:00" or "2013-02-08T17:30:00" (time must be in UTC)

Column

PHONE

What is fetched

Phone number and ISO 2-letter Country code separated by colon

Example

"42069420:US"

Column

TEXT

What is fetched

Simple text

Example

"Lorem ipsum dolor sit amet"

Column

CHECKBOX

What is fetched

Boolean value

Example

true if column is checked, false otherwise

Column

NUMBERS

What is fetched

Simple numbers

Example

123

Column

COUNTRY

What is fetched

ISO 2-letter Country code:Country name

Example

"UK" or "US"

Column

DROPDOWN

What is fetched

id:labels separated by plus

Example

1:test+2:test 2+3:test3 or “test”

Column

EMAIL

What is fetched

Email address and displayed name separated by colon

Example

"[e-mail]:Company Inc."

Column

FILE (read only)

What is fetched

One or more file names separated by plus

Example

"document.doc" or "document.doc+data.xls"

Column

HOUR

What is fetched

ISO 8601 time

Example

"17:30"

Column

LINK

What is fetched

Web address and displayed text separated by colon. Escape : occurrences in the URL with .

Example

"https://monday.com:Monday" or "https://monday.com?key:value:Monday link including :"

Column

LOCATION

What is fetched

Latitude, longitude and displayed text separated by colon

Example

"45.438611:12.326667:London"

Column

LONG_TEXT

What is fetched

Simple text

Example

"Lorem ipsum dolor sit amet"

Column

RATING

What is fetched

A number between 1 and the rating scale defined in the column

Example

5

Column

TAGS

What is fetched

One or more tag IDs separated by plus

Example

"69420" or "69420+42069"

Column

TIME_TRACKING (read only)

What is fetched

Time passed in HH:MM:SS format

Example

01:23:45 for 1 hour, 23 mins and 45 secs

Column

TIMELINE

What is fetched

Two ISO 8601 dates separated by plus

Example

"2013-02-08+2013-02-20"

Column

WEEK

What is fetched

Two ISO 8601 dates separated by plus starting at the beginning of the week defined in your account and ending 7 days later

Example

"2013-02-08+2013-02-14"

Column

WORLD_CLOCK

What is fetched

ISO timezone

Example

"Europe/London"

Column

ITEM NAME

What is fetched

Name of the item

Example

"Item 1"

Column

ITEM GROUP

What is fetched

Group of the item

Example

"Group Title"

Column

MIRROR

What is fetched

One or more values separated by plus

Example

"69420" if only one item is linked or "69420+42069" if two items are linked

Column

SUBITEMS

What is fetched

Example

INCOMPATIBLE COLUMNS

Autonumber, Color Picker, Mirror, Progress Tracking