Supported Columns

Target columns, simple and complex source columns, column properties with hash notation, meta resources, and unsupported column types.

Formula Trigga works with two kinds of columns: target columns (where formula results are written) and source columns (whose values your formula reads). Not every monday.com column type is supported.

Target Columns

A target column is the column you attach Formula Trigga to. Formula results are written here, triggering any automations watching it.

Column Type	What Your Formula Can Write
Text	Any string
Numbers	Any number
Date	Date in YYYY-MM-DD format
Status	Status label string (e.g. `"Done"`)
People	People assignments (via bare column ref)
Long Text	Any string
Email	Email address string
Dropdown	Label string(s), comma-separated

When your formula writes "Option1, Option2" to a Dropdown column, it becomes two separate labels. Be aware of this if your formula produces comma-containing text.

Simple Source Columns

Simple source columns return a single value when referenced with {Column Name}.

Column Type	What `{Column Name}` Returns	Return Type	When Empty
Text	Text content	String	`""`
Numbers	Numeric value	Number	`0`
Status	Status label	String	`"Empty"`
Date	Date string (YYYY-MM-DD)	String	`""`
Email	Email address	String	`""`
Phone	Phone number	String	`""`
Long Text	Text content	String	`""`
Link	URL text	String	`""`
Checkbox	Checked state	Boolean	`false`
Rating	Rating value	Number	`0`
Country	Country name	String	`""`
Hour	Time as "HH:MM"	String	`""`
Item ID	Item ID string	String	`""`

Status columns return "Empty" — not an empty string. Write IF({Status} == "Empty", ...) instead of IF({Status} == "", ...).

Complex Source Columns

Complex source columns have multiple values you can access through properties using hash notation: {Column Name#Property}. See the property reference tables below for each type.

Column Type	Available Properties
People	Names, Count, Ids, Emails, PhoneNumbers
Person (legacy)	Names, Count, Ids, Emails, PhoneNumbers
Timeline	Start, End
Location	Address, Country, CountryShort, City, CityShort, Street, StreetShort, StreetNumber
Dropdown	Labels, Count
Vote	Count, Names
Time Tracking	Seconds, Minutes, Hours
Last Updated	Name, Date, DateTime
Creation Log	Name, Date, DateTime
Subtasks	Names, Count
Board Relation	Names, Count
Dependency	Names, Count

People and Person have identical properties — Person is the legacy single-person variant.

{People Column} (without a property) returns a special entity array. This only works when writing to a People target column — it copies the assigned people. For text output, always use {People Column#Names}.

Column Properties

Use hash notation to access specific properties of complex columns:

{Column Name#Property}

{People Column#Count} returns the number of assigned people. {Timeline#Start} returns the start date.

The bare reference {Column Name} (without a property) returns a default value — usually the primary display value. For most complex types, this is the comma-separated names or labels.

People / Person

Property	Returns	Type	When Empty
`#Names`	Comma-separated names	String	`""`
`#Count`	Number of assigned people	Number	`0`
`#Ids`	Comma-separated user IDs	String	`""`
`#Emails`	Comma-separated emails	String	`""`
`#PhoneNumbers`	Comma-separated phone numbers	String	`""`

IF({Assignee#Count} > 1, "Team task", "Individual task")

Timeline

Property	Returns	Type	When Empty
`#Start`	Start date (YYYY-MM-DD)	String	`""`
`#End`	End date (YYYY-MM-DD)	String	`""`

DAYS({Timeline#End}, {Timeline#Start})

Location

Property	Returns	Type	When Empty
`#Address`	Full address	String	`""`
`#Country`	Country name	String	`""`
`#CountryShort`	Country code (e.g. "US")	String	`""`
`#City`	City name	String	`""`
`#CityShort`	City abbreviation	String	`""`
`#Street`	Street name	String	`""`
`#StreetShort`	Street abbreviation	String	`""`
`#StreetNumber`	Street number	String	`""`

CONCATENATE({Office#City}, ", ", {Office#CountryShort})

Property	Returns	Type	When Empty
`#Labels`	Comma-separated selected labels	String	`""`
`#Count`	Number of selected options	Number	`0`

IF({Tags#Count} > 0, {Tags#Labels}, "No tags")

Vote

Property	Returns	Type	When Empty
`#Count`	Number of votes	Number	`0`
`#Names`	Comma-separated voter names	String	`""`

IF({Feature Vote#Count} >= 5, "Popular", "Needs votes")

Time Tracking

Property	Returns	Type	When Empty
`#Seconds`	Total tracked seconds	Number	`0`
`#Minutes`	Total tracked minutes	Number	`0`
`#Hours`	Total tracked hours	Number	`0`

IF({Time Tracking#Hours} > 8, "Over budget", "On track")

Last Updated

Property	Returns	Type	When Empty
`#Name`	Name of the person who last updated	String	`""`
`#Date`	Date of last update (YYYY-MM-DD)	String	`""`
`#DateTime`	Date and time (YYYY-MM-DD HH:MM)	String	`""`

CONCATENATE("Last updated by ", {Last Updated#Name}, " on ", {Last Updated#Date})

Creation Log

Property	Returns	Type	When Empty
`#Name`	Name of the item creator	String	`""`
`#Date`	Creation date (YYYY-MM-DD)	String	`""`
`#DateTime`	Creation date and time (YYYY-MM-DD HH:MM)	String	`""`

DAYS(TODAY(), {Creation Log#Date})

Subtasks

Property	Returns	Type	When Empty
`#Names`	Comma-separated subitem names	String	`""`
`#Count`	Number of subitems	Number	`0`

IF({Subtasks#Count} == 0, "No subitems", CONCATENATE({Subtasks#Count}, " subitems"))

Board Relation

Property	Returns	Type	When Empty
`#Names`	Comma-separated linked item names	String	`""`
`#Count`	Number of linked items	Number	`0`

IF({Linked Projects#Count} > 0, "Has dependencies", "Independent")

Dependency

Property	Returns	Type	When Empty
`#Names`	Comma-separated dependency names	String	`""`
`#Count`	Number of dependencies	Number	`0`

IF({Dependencies#Count} == 0, "Ready", "Blocked")

Meta Resources

Meta resources give you access to item-level and board-level information without referencing a specific column.

Reference	Returns	Return Type
`{Name}`	Item name	String
`{Board}`	Board name	String
`{Group}`	Group name	String

CONCATENATE({Name}, " — ", {Group})

Unsupported Columns

These column types cannot be referenced in formulas:

Column Type	Why
Mirror	Read-only reflection of linked board data — no direct access
Formula	monday.com's native formula column — read-only, circular dependency risk
Progress	Computed value, no structured data
Tags	No structured data access
Doc / Docs	Document content, not a data column
Auto Number	System-generated, read-only
Button	Action trigger, no data value
Week	No structured data access
Color Picker	No structured data access
File	Binary content, not a data value

If your formula needs data from a mirrored column, reference the original column on the linked board instead. If you need data from a native formula column, recreate the calculation in Formula Trigga.

Next Steps

Parent Column References — reference parent item data in subitem formulas
Writing Formulas — syntax, operators, empty values, and limits
Troubleshooting — health view, common errors, FAQ, and support

On this page