Reading and Writing Specifics by Column Type

In this page, we cover the specifics of each monday.com column regarding how to read from and write to them.

• Checkbox columns
• Country columns
• Date columns
• Dropdown columns
• Email columns
• Hour columns
• Item names
• Link columns
• Location columns
• Long Text columns
• Number columns
• People columns
• Phone columns
• Rating columns
• Status columns
• Tags columns
• Text columns
• Timeline columns
• Week columns
• World Clock columns

Finally we explain How to clear column values.

Checkbox columns

To read a Checkbox column, use the {Column} placeholder. The returned value will be either 0 (not checked) or 1 (checked).

To write to a Checkbox column, use 0 to uncheck it and 1 to check it.

Country columns

To read a Country column, use the {Column} placeholder. The returned value will be the two-letter abbreviation for the country.

To write to a Country column, use either the two-letter abbreviation or the English name. Here is the Full List of Country Codes.

Or

Note than when testing in the Formula Editor, the Advanced Formula Booster will check the possible values for the Country column and indicate if the value you enter is incorrect.

Date columns

To read a Date column, use the {Column} placeholder. The returned value will be in the YYYY-MM-DD format.

To write to a Date column, use the same format.

Dropdown columns

See Interacting with Multi-Value Columns (People, Dropdown and Tags)

Email columns

In monday, the Email column displays the email as a clickable link. The text of the clickable link is the email address unless you specify a text to be used in its place.

To read an Email column, use the {Column} placeholder. It will return the email and the text separated by a comma or only the email address if no text was provided.

To write to an Email column, enclose the email address between double quotes. Note than when you run a test in the Formula Editor, the Advanced Formula Booster will check the address and indicate if the email is not a valid email address.

If you want to include a text for the link, use this syntax:

Hour columns

See Numbers column.

Item names

The Item name is not a column per se, but you can read it and modify it. To read the Item name, use the {Name} placeholder.

To change the Item name, simply enter the name between double quotes.

Link columns

The Link column works similar to the Email column. It displays the URL as a clickable link. The text of the clickable link is the URL unless you specify a different text to be used.

To read a Link column, use the {Column} placeholder. It will return the URL and the text separated by a comma or only the URL if no text was provided.

To write to a Link column, enclose the URL of the link between double quotes. Note than when you run a test in the Formula Editor, the Advanced Formula Booster will check the URL and indicate if it is a valid URL. Make sure you include https:// or http://.

If you want to include a text for the link, use this syntax:

Location columns

The Location column displays a clickable location made of a latitude and a longitude and optionally a text to identify the location.

To read a Location column, use the {Column} placeholder. It will return the latitude, longitude and text (if provided) separated by a comma.

To write to a Location column, enclose the latitude and longitude between double quotes. Note than when you run a test in the Formula Editor, the Advanced Formula Booster will check both and indicate if they are not valid coordinates.

If you want to include a text for the location, use this syntax:

Long Text columns

To read a Long Text column, use the {Column} placeholder.

To write to a Long Text column, enter the tags between double quotes.

If you want your text to be split across multiple lines, use the LINES function.

Number columns

To read a Number column, use the {Column} placeholder.

To write to a Number column, simply enter the number. No need to enclose it between double quotes, but double quotes will not hurt if you include them.

People columns

See Interacting with Multi-Value Columns (People, Dropdown and Tags)

Phone columns

If you look at a Phone column in monday.com, you see a phone number and optionally a flag corresponding to the country of the phone number. In most cases, monday.com figures out the country when you type the phone number.

To read a Phone column, use the {Column} placeholder. It will return the phone number followed by the two-letter country code.

To write to a Phone column, enter the phone number (including the numeric country code) and the two-letter country code, separated by a comma.

The two-letter country code is not mandatory, but if you do not include it, no flag will be displayed next to the number. In other words, monday.com will not try to figure out the country of the number should you omit it.

Rating columns

See Numbers column.

Status columns

To read a Status column, use the {Column} placeholder.

To write to a Status column, enter the status between double quotes. Note than when you run a test in the Formula Editor, the Advanced Formula Booster will check the possible values for the Status column and indicate if the value you entered is incorrect.

Tags columns

See Interacting with Multi-Value Columns (People, Dropdown and Tags)

Text columns

To read a Text column, use the {Column} placeholder.

To write to a Text column, enter the tags between double quotes.

Timeline columns

To read a Timeline column, use the {Column} placeholder. It returns both dates separated with a comma.

Should you only want to get the start or end date, use {Column#Start} and {Column#End}. Both options are available in the Column Selector pop-up.

#Start and #End are for reading only. You cannot write to them (the editor will indicate an error if you try to assign a value to them).

To write to a Timeline column, enter the two dates separated by a comma. You cannot use {Column#Start} and {Column#End} to write to a timeline.

If your start and end dates are in columns or variables, use the TIMELINE function.

The TIMELINE function takes either two dates as parameters (as shown above) or one date and a number (the duration). That number can be negative if you want to go backward.

The order of the dates is not important. The Advanced Formula Booster will always put the earlier date first.

Week columns

To read a Week column, use the {Column} placeholder. It returns the start date followed by the end date (6 days later) separated with a comma.

Should you only want to get the start or end date, use {Column#Start} and {Column#End}. Both options are available in the Column Selector pop-up.

#Start and #End are for reading only. You cannot write to them (the editor will indicate an error if you try to assign a value to them).

To write to a Week column, you only need to enter a date in the week of your choice. The Advanced Formula Booster will calculate which week it is in.

World Clock columns

To read a World Clock column, use the {Column} placeholder. It returns the time zone.

To write to a Timeline column, enter the time zone between double-quotes.

How to clear column values

To clear any of the columns mentioned above, simply use the CLEAR() function:

or alternatively: